243: pps.person_id,
244: pps.final_process_date
245: from pay_assignment_actions pac,
246: per_assignments_f paa,
247: per_periods_of_service pps
248: where pac.assignment_action_id = p_assignment_action_id
249: and paa.assignment_id = pac.assignment_id
250: and pps.person_id = paa.person_id
251: order by pps.date_start desc;