APPS.PQH_PQHEEO4_XMLP_PKG dependencies on HR_LOOKUPS

Line 56: hr_lookups hl

52: per_assignment_status_types ast1,
53: per_pay_proposals ppp,
54: per_jobs job,
55: per_pay_bases ppb,
56: hr_lookups hl
57: WHERE peo.person_id = ass.person_id
58: AND ass.pay_basis_id = ppb.pay_basis_id
59: AND ass.assignment_id = ppp.assignment_id
60: AND hl.lookup_code = job.job_information1

Line 332: HR_LOOKUPS

328: CURSOR FUNC_DESC_CUR IS
329: SELECT
330: MEANING
331: FROM
332: HR_LOOKUPS
333: WHERE LOOKUP_TYPE = 'US_EEO4_JOB_FUNCTIONS'
334: AND LOOKUP_CODE = JOB_FUNCTION_CODE;
335: L_FUNCTION_DESC VARCHAR2(240);
336: BEGIN