37: cp_stperson number,
38: cp_endperson number
39: ) is
40: select distinct paf.assignment_id
41: from per_periods_of_service pos,
42: per_all_assignments_f paf,
43: pay_payroll_actions ppa
44: where ppa.payroll_action_id = cp_pactid
45: and ppa.business_group_id = paf.business_group_id