APPS.HRI_OPL_DATA_SETUP_DGNSTC dependencies on FND_PROFILE

Line 563: NVL(fnd_profile.value('HRI_LOG_PRCSS_INFO'),'Y') = 'Y'))

559: hri_adm_dgnstc_setup stp
560: WHERE stp.enabled_flag = 'Y'
561: AND ((stp.report_type = 'DATA' AND p_show_data = 'Y')
562: OR (stp.report_type = 'ALERT' AND p_show_alerts = 'Y' AND
563: NVL(fnd_profile.value('HRI_LOG_PRCSS_INFO'),'Y') = 'Y'))
564: AND ((stp.foundation_hr_flag ='Y' AND hri_bpl_system.is_full_hr_installed='N')
565: OR hri_bpl_system.is_full_hr_installed='Y' )
566: AND EXISTS
567: (SELECT null