APPS.PQH_PQIPED6_XMLP_PKG dependencies on HR_LOOKUPS

Line 165: hr_lookups hl

161: per_assignment_status_types ast,
162: per_jobs job,
163: per_pay_proposals ppp,
164: per_pay_bases ppb,
165: hr_lookups hl
166: WHERE peo.person_id = ass.person_id
167: AND peo.current_employee_flag = 'Y'
168: AND hl.lookup_code = job.job_information8
169: AND job.job_information8 NOT IN('1', '2', '3', '4')

Line 221: hr_lookups hl,

217: per_assignment_status_types ast,
218: per_jobs job,
219: per_pay_proposals ppp,
220: per_pay_bases ppb,
221: hr_lookups hl,
222: per_people_extra_info pei
223: WHERE peo.person_id = ass.person_id
224: AND peo.current_employee_flag = 'Y'
225: AND peo.per_information1 = '13'