To Check debug logging is enabled or disable


SELECT
tl.user_profile_option_name
,substr(decode(a.level_id,10001,'SITE',
10002,'APPLN',10003,'RESP',10004,'USER'),1,5) "Level"
,substr(decode(a.level_id,10001,'Site',10002,c.application_short_name,10003
,b.responsibility_name,10004,d.user_name),1,30) "Level Value"
,nvl(a.profile_option_value,'Is Null') "Profile Value"
FROM fnd_profile_option_values a
,fnd_responsibility_tl b
,fnd_application c
,fnd_user d
,fnd_profile_options e
,fnd_profile_options_tl tl
WHERE tl.profile_option_name= ('AFLOG_ENABLED')
AND e.profile_option_id = a.profile_option_id
AND tl.profile_option_name = e.profile_option_name
AND a.level_value = b.responsibility_id (+)
AND a.level_value = c.application_id (+)
AND a.level_value = d.user_id (+)
ORDER BY 1, 2, 3, 4 DESC