54: cp_endperson number
55: ) is
56: select distinct ppe.assignment_id,ppe.creation_date
57: from
58: per_all_assignments_f paf,
59: per_periods_of_service pos,
60: pay_payroll_actions ppa,
61: pay_process_events ppe
62: where ppa.payroll_action_id = cp_pactid