APPS.PER_US_EEO4A_PKG dependencies on HR_LOOKUPS

Line 393: FROM hr_lookups

389:
390: CURSOR get_eeo4_lookup_details
391: IS
392: SELECT lookup_code, meaning, description
393: FROM hr_lookups
394: WHERE lookup_type = 'US_EEO4_JOB_CATEGORIES'
395: ORDER BY lookup_code;
396:
397: BEGIN

Line 573: FROM hr_lookups

569: l_no_cons_ofemale_emps NUMBER := 0;
570:
571: CURSOR get_eeo4_lookup_details IS
572: SELECT lookup_code, meaning, description
573: FROM hr_lookups
574: WHERE lookup_type = 'US_EEO4_JOB_CATEGORIES'
575: ORDER BY lookup_code;
576: BEGIN
577:

Line 720: FROM hr_lookups

716: /* Job Category is same for both EEO4 and EEO4A ethnic origins */
717: CURSOR get_eeo4_lookup_details
718: IS
719: SELECT lookup_code, meaning, description
720: FROM hr_lookups
721: WHERE lookup_type = 'US_EEO4_JOB_CATEGORIES'
722: ORDER BY lookup_code;
723:
724: BEGIN

Line 989: FROM hr_lookups

985: /** Job Category is same for EEO4 and EEO4A Ethnic origins **/
986: CURSOR get_eeo4_lookup_details
987: IS
988: SELECT lookup_code, meaning, description
989: FROM hr_lookups
990: WHERE lookup_type = 'US_EEO4_JOB_CATEGORIES'
991: ORDER BY lookup_code;
992:
993: BEGIN

Line 1528: FROM hr_lookups

1524:
1525: CURSOR get_eeo4_lookup_details
1526: IS
1527: SELECT lookup_code, meaning, description
1528: FROM hr_lookups
1529: WHERE lookup_type = 'US_EEO4_JOB_CATEGORIES'
1530: ORDER BY lookup_code;
1531:
1532: CURSOR func_desc_cur(l_lookup_code VARCHAR)

Line 1535: FROM hr_lookups

1531:
1532: CURSOR func_desc_cur(l_lookup_code VARCHAR)
1533: IS
1534: SELECT meaning
1535: FROM hr_lookups
1536: WHERE lookup_type = 'US_EEO4_JOB_FUNCTIONS'
1537: AND lookup_code = l_lookup_code;
1538:
1539: BEGIN

Line 1561: hr_lookups hl

1557: per_assignment_status_types past,
1558: per_pay_proposals ppp,
1559: per_jobs job,
1560: per_pay_bases ppb,
1561: hr_lookups hl
1562: WHERE peo.person_id = ass.person_id
1563: AND ass.pay_basis_id = ppb.pay_basis_id
1564: AND ass.assignment_id = ppp.assignment_id
1565: AND hl.lookup_code = job.job_information1