APPS.PER_US_EEO4_PKG dependencies on HR_LOOKUPS

Line 486: FROM hr_lookups

482:
483: -- Dynamic SQL Variables
484: CURSOR get_eeo4_lookup_details IS
485: SELECT lookup_code, meaning, description
486: FROM hr_lookups
487: WHERE lookup_type = 'US_EEO4_JOB_CATEGORIES'
488: ORDER BY lookup_code;
489:
490: CURSOR func_desc_cur(l_lookup_code VARCHAR) IS

Line 492: FROM hr_lookups

488: ORDER BY lookup_code;
489:
490: CURSOR func_desc_cur(l_lookup_code VARCHAR) IS
491: SELECT meaning
492: FROM hr_lookups
493: WHERE lookup_type = 'US_EEO4_JOB_FUNCTIONS'
494: AND lookup_code = l_lookup_code;
495:
496: BEGIN

Line 533: hr_lookups hl

529: per_assignment_status_types past,
530: per_pay_proposals ppp,
531: per_jobs job,
532: per_pay_bases ppb,
533: hr_lookups hl
534: WHERE peo.person_id = ass.person_id
535: AND ass.pay_basis_id = ppb.pay_basis_id
536: AND ass.assignment_id = ppp.assignment_id
537: AND hl.lookup_code = job.job_information1

Line 591: hr_lookups hl,

587: per_assignment_status_types past,
588: per_pay_proposals ppp,
589: per_jobs job,
590: per_pay_bases ppb,
591: hr_lookups hl,
592: per_people_extra_info pei
593: WHERE peo.person_id = ass.person_id
594: AND peo.per_information1 = ''13''
595: AND peo.person_id = pei.person_id(+)

Line 1204: FROM hr_lookups

1200:
1201:
1202: CURSOR get_eeo4_lookup_details IS
1203: SELECT lookup_code, meaning, description
1204: FROM hr_lookups
1205: WHERE lookup_type = 'US_EEO4_JOB_CATEGORIES'
1206: ORDER BY lookup_code;
1207:
1208:

Line 1500: FROM hr_lookups

1496:
1497:
1498: CURSOR get_eeo4_lookup_details IS
1499: SELECT lookup_code, meaning, description
1500: FROM hr_lookups
1501: WHERE lookup_type = 'US_EEO4_JOB_CATEGORIES'
1502: ORDER BY lookup_code;
1503:
1504: BEGIN

Line 1721: FROM hr_lookups

1717: Commented for bug#11736960 ends */
1718:
1719: CURSOR get_eeo4_lookup_details IS
1720: SELECT lookup_code, meaning, description
1721: FROM hr_lookups
1722: WHERE lookup_type = 'US_EEO4_JOB_CATEGORIES'
1723: ORDER BY lookup_code;
1724:
1725: BEGIN

Line 1947: FROM hr_lookups

1943:
1944:
1945: CURSOR get_eeo4_lookup_details IS
1946: SELECT lookup_code, meaning, description
1947: FROM hr_lookups
1948: WHERE lookup_type = 'US_EEO4_JOB_CATEGORIES'
1949: ORDER BY lookup_code;
1950:
1951: BEGIN