DBA Data[Home] [Help]

APPS.HRI_OPL_SETUP_DIAGNOSTIC dependencies on HRI_BPL_SYSTEM

Line 184: hri_bpl_system.is_full_hr_installed = 'N')

180: AND sbs.functional_area_cd = p_functional_area
181: AND (p_object_name IS NULL OR stp.object_name = p_object_name)
182: AND stp.enabled_flag='Y'
183: AND ((stp.foundation_hr_flag = 'Y' AND
184: hri_bpl_system.is_full_hr_installed = 'N')
185: OR hri_bpl_system.is_full_hr_installed = 'Y')
186: ORDER BY 1;
187:
188: -- Cursor returning all diagnostics for a given type

Line 185: OR hri_bpl_system.is_full_hr_installed = 'Y')

181: AND (p_object_name IS NULL OR stp.object_name = p_object_name)
182: AND stp.enabled_flag='Y'
183: AND ((stp.foundation_hr_flag = 'Y' AND
184: hri_bpl_system.is_full_hr_installed = 'N')
185: OR hri_bpl_system.is_full_hr_installed = 'Y')
186: ORDER BY 1;
187:
188: -- Cursor returning all diagnostics for a given type
189: CURSOR c_objects_all IS

Line 197: hri_bpl_system.is_full_hr_installed = 'N')

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
197: hri_bpl_system.is_full_hr_installed = 'N')
198: OR hri_bpl_system.is_full_hr_installed = 'Y')
199: ORDER BY 1;
200:
201: l_object_tab g_varchar2_tab_type;

Line 198: OR hri_bpl_system.is_full_hr_installed = 'Y')

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
197: hri_bpl_system.is_full_hr_installed = 'N')
198: OR hri_bpl_system.is_full_hr_installed = 'Y')
199: ORDER BY 1;
200:
201: l_object_tab g_varchar2_tab_type;
202: