DBA Data[Home] [Help]

APPS.HRI_OPL_SETUP_DIAGNOSTIC dependencies on HRI_ADM_DGNSTC_SETUP

Line 175: hri_adm_dgnstc_setup stp

171: CURSOR c_objects IS
172: SELECT
173: stp.object_name
174: FROM
175: hri_adm_dgnstc_setup stp
176: ,hri_adm_dgnstc_sbscrb sbs
177: WHERE stp.object_type= p_object_type
178: AND stp.object_name = sbs.object_name
179: AND stp.object_type = sbs.object_type

Line 192: hri_adm_dgnstc_setup stp

188: -- Cursor returning all diagnostics for a given type
189: CURSOR c_objects_all IS
190: SELECT stp.object_name
191: FROM
192: hri_adm_dgnstc_setup stp
193: WHERE stp.object_type= p_object_type
194: AND (p_object_name IS NULL OR stp.object_name = p_object_name)
195: AND stp.enabled_flag='Y'
196: AND ((stp.foundation_hr_flag = 'Y' AND