[Home] [Help]
241: SELECT DISTINCT paf.assignment_id
242: FROM per_assignments_f paf
243: ,per_people_f ppf
244: ,pay_payroll_actions ppa
245: ,hr_assignment_set_amendments has
246: WHERE ppa.payroll_action_id = c_payroll_action_id
247: AND ppf.person_id BETWEEN c_start_person_id AND c_end_person_id
248: AND ppf.person_id = paf.person_id
249: AND paf.assignment_id = has.assignment_id