[Home] [Help]
103: -- Used per_people_f 4555600
104: -- Changed the cursor to reduce the cost (5042843)
105: sqlstr := 'SELECT distinct asg.person_id
106: FROM per_periods_of_service pos,
107: per_assignments_f asg,
108: pay_payroll_actions ppa
109: WHERE ppa.payroll_action_id = :payroll_action_id
110: AND pos.person_id = asg.person_id
111: AND pos.period_of_service_id = asg.period_of_service_id
142: paa.assignment_id,
143: paa.payroll_action_id,
144: ppa.date_earned,
145: paa_run.tax_unit_id
146: from per_assignments_f asg,
147: pay_payroll_actions pp1,
148: pay_assignment_actions paa,
149: pay_payroll_actions ppa,
150: pay_action_interlocks pai_pre,
256: ppa.date_earned,
257: paa.tax_unit_id
258: from pay_payroll_actions ppa,
259: pay_assignment_actions paa
260: -- per_assignments_f asg -- Bug Fix 4260031
261: where ppa.payroll_action_id = l_pay_action_id
262: -- and asg.business_group_id = ppa.business_group_id -- Bug Fix 4260031
263: -- and asg.person_id between stperson and endperson
264: -- and asg.assignment_id = paa.assignment_id
265: and paa.source_action_id is null
266: and paa.payroll_action_id = ppa.payroll_action_id
267: -- and ppa.date_earned between asg.effective_start_date and asg.effective_end_date
268: and paa.assignment_id in (select asg.assignment_id -- Bug Fix 4260031
269: from per_assignments_f asg
270: where asg.business_group_id = ppa.business_group_id
271: and asg.person_id between stperson and endperson)
272: and ppa.action_status = 'C'
273: and ppa.action_type = 'X'