13: begin
14: --
15: sqlstr := 'select distinct asg.person_id
16: from
17: per_all_assignments_f asg,
18: pay_payroll_actions pa1
19: where pa1.payroll_action_id = :payroll_action_id
20: and asg.business_group_id = pa1.business_group_id
21: order by asg.person_id';
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
46: and pos.period_of_service_id = paf.period_of_service_id
92: is
93: select paf.assignment_id
94: , paf.business_group_id
95: from pay_temp_object_actions toa
96: , per_all_assignments_f paf
97: where toa.object_action_id = p_ass_act_id
98: and toa.object_type = 'ASG'
99: and toa.object_id = paf.assignment_id
100: and p_eff_date between paf.effective_start_date