APPS.PER_ES_ORG_INFO dependencies on DUAL

Line 26: SELECT 'Y' FROM dual

22: FROM hr_all_organization_units
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: --

Line 222: SELECT 'Y' FROM dual

218: WHERE hoi.org_information_id = p_org_information_id
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: --