APPS.PAY_GB_ENROLL_PENSION dependencies on HR_LOOKUPS

Line 1872: FROM hr_lookups

1868: AND G_PRP_END_DATE BETWEEN a.effective_start_date AND a.effective_end_date;
1869: CURSOR c_employment_category(p_emp_category VARCHAR2)
1870: IS
1871: SELECT 1
1872: FROM hr_lookups
1873: WHERE lookup_type = 'EMP_CAT'
1874: AND meaning = p_emp_category
1875: AND lookup_code IN
1876: (SELECT EMPLOYMENT_CATEGORY