229: ,per_all_assignments_f paa
230: ,per_all_people_f pap
231: ,per_periods_of_service ppf
232: ,hr_organization_information hoi
233: ,hr_all_organization_units hou
234: WHERE ppa.payroll_action_id = c_pact_id
235: AND pap.person_id = paa.person_id
236: AND pap.person_id BETWEEN c_stperson
237: AND c_endperson