APPS.PER_ES_ORG_INFO dependencies on HR_LOOKUPS

Line 27: WHERE EXISTS (SELECT /*+ ORDERED */ NULL from hr_lookups

23: WHERE organization_id=p_organization_id;
24: --
25: CURSOR csr_chk_province_code(c_prov_code VARCHAR2) IS
26: SELECT 'Y' FROM dual
27: WHERE EXISTS (SELECT /*+ ORDERED */ NULL from hr_lookups
28: WHERE LOOKUP_TYPE = 'ES_PROVINCE_CODES'
29: AND LOOKUP_CODE = c_prov_code);
30: --
31: CURSOR csr_chk_contribution_ac_type(c_business_group_id NUMBER

Line 223: WHERE EXISTS (SELECT /*+ ORDERED */ NULL from hr_lookups

219: AND hoi.organization_id = hou.organization_id;
220: --
221: CURSOR csr_chk_province_code(c_prov_code VARCHAR2) IS
222: SELECT 'Y' FROM dual
223: WHERE EXISTS (SELECT /*+ ORDERED */ NULL from hr_lookups
224: WHERE LOOKUP_TYPE = 'ES_PROVINCE_CODES'
225: AND LOOKUP_CODE = c_prov_code);
226: --
227: CURSOR csr_chk_contribution_ac_type(c_business_group_id NUMBER