[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,
262: ppa.date_earned,
263: paa.tax_unit_id
264: from pay_payroll_actions ppa,
265: pay_assignment_actions paa
266: -- per_assignments_f asg -- Bug Fix 4260031
267: where ppa.payroll_action_id = l_pay_action_id
268: -- and asg.business_group_id = ppa.business_group_id -- Bug Fix 4260031
269: -- and asg.person_id between stperson and endperson
270: -- and asg.assignment_id = paa.assignment_id
271: and paa.source_action_id is null
272: and paa.payroll_action_id = ppa.payroll_action_id
273: -- and ppa.date_earned between asg.effective_start_date and asg.effective_end_date
274: and paa.assignment_id in (select asg.assignment_id -- Bug Fix 4260031
275: from per_assignments_f asg
276: where asg.business_group_id = ppa.business_group_id
277: and asg.person_id between stperson and endperson)
278: and ppa.action_status = 'C'
279: and ppa.action_type = 'X'