160: per_all_assignments_f ass,
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
216: per_all_assignments_f ass,
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'