APPS.PER_US_EEO4_PKG dependencies on HR_LOOKUPS

Line 436: FROM hr_lookups

432:
433: -- Dynamic SQL Variables
434: CURSOR get_eeo4_lookup_details IS
435: SELECT lookup_code, meaning, description
436: FROM hr_lookups
437: WHERE lookup_type = 'US_EEO4_JOB_CATEGORIES'
438: ORDER BY lookup_code;
439:
440: CURSOR func_desc_cur(l_lookup_code VARCHAR) IS

Line 442: FROM hr_lookups

438: ORDER BY lookup_code;
439:
440: CURSOR func_desc_cur(l_lookup_code VARCHAR) IS
441: SELECT meaning
442: FROM hr_lookups
443: WHERE lookup_type = 'US_EEO4_JOB_FUNCTIONS'
444: AND lookup_code = l_lookup_code;
445:
446: BEGIN

Line 467: hr_lookups hl

463: per_assignment_status_types past,
464: per_pay_proposals ppp,
465: per_jobs job,
466: per_pay_bases ppb,
467: hr_lookups hl
468: WHERE peo.person_id = ass.person_id
469: AND ass.pay_basis_id = ppb.pay_basis_id
470: AND ass.assignment_id = ppp.assignment_id
471: AND hl.lookup_code = job.job_information1

Line 509: hr_lookups hl,

505: per_assignment_status_types past,
506: per_pay_proposals ppp,
507: per_jobs job,
508: per_pay_bases ppb,
509: hr_lookups hl,
510: per_people_extra_info pei
511: WHERE peo.person_id = ass.person_id
512: AND peo.per_information1 = ''13''
513: AND peo.person_id = pei.person_id(+)

Line 1073: FROM hr_lookups

1069:
1070:
1071: CURSOR get_eeo4_lookup_details IS
1072: SELECT lookup_code, meaning, description
1073: FROM hr_lookups
1074: WHERE lookup_type = 'US_EEO4_JOB_CATEGORIES'
1075: ORDER BY lookup_code;
1076:
1077:

Line 1337: FROM hr_lookups

1333:
1334:
1335: CURSOR get_eeo4_lookup_details IS
1336: SELECT lookup_code, meaning, description
1337: FROM hr_lookups
1338: WHERE lookup_type = 'US_EEO4_JOB_CATEGORIES'
1339: ORDER BY lookup_code;
1340:
1341: BEGIN

Line 1554: FROM hr_lookups

1550: l_no_tmr_ifemale_emps NUMBER := 0;
1551:
1552: CURSOR get_eeo4_lookup_details IS
1553: SELECT lookup_code, meaning, description
1554: FROM hr_lookups
1555: WHERE lookup_type = 'US_EEO4_JOB_CATEGORIES'
1556: ORDER BY lookup_code;
1557:
1558: BEGIN

Line 1778: FROM hr_lookups

1774:
1775:
1776: CURSOR get_eeo4_lookup_details IS
1777: SELECT lookup_code, meaning, description
1778: FROM hr_lookups
1779: WHERE lookup_type = 'US_EEO4_JOB_CATEGORIES'
1780: ORDER BY lookup_code;
1781:
1782: BEGIN