[Home] [Help]
174: )
175: , 24))
176: into l_assignment_action_id
177: from pay_assignment_actions paa,
178: pay_payroll_actions ppa
179: where paa.assignment_id = p_assignment_id
180: and paa.action_status = 'C'
181: and ppa.payroll_action_id = paa.payroll_action_id
182: and ppa.date_earned
191: )
192: , 16))
193: into l_assignment_action_id
194: from pay_assignment_actions paa,
195: pay_payroll_actions ppa
196: where paa.assignment_id = p_assignment_id
197: and paa.action_status = 'C'
198: and ppa.payroll_action_id = paa.payroll_action_id
199: and ppa.effective_date
225: and asg2.person_id = asg.person_id
226: group by asg2.assignment_id
227: ) v,
228: pay_assignment_actions paa,
229: pay_payroll_actions ppa
230: where paa.assignment_id = v.assignment_id
231: and paa.action_status = 'C'
232: and ppa.payroll_action_id = paa.payroll_action_id
233: and ppa.date_earned
252: and asg2.person_id = asg.person_id
253: group by asg2.assignment_id
254: ) v,
255: pay_assignment_actions paa,
256: pay_payroll_actions ppa
257: where paa.assignment_id = v.assignment_id
258: and paa.action_status = 'C'
259: and ppa.payroll_action_id = paa.payroll_action_id
260: and ppa.effective_date
302: )
303: , 16))
304: into l_assignment_action_id
305: from pay_assignment_actions paa,
306: pay_payroll_actions ppa
307: where paa.assignment_id = p_assignment_id
308: and paa.action_status = 'C'
309: and ppa.payroll_action_id = paa.payroll_action_id
310: and ppa.time_period_id = l_assignment_rec.time_period_id
333: and asg2.person_id = asg.person_id
334: group by asg2.assignment_id
335: ) v,
336: pay_assignment_actions paa,
337: pay_payroll_actions ppa
338: where paa.assignment_id = v.assignment_id
339: and paa.action_status = 'C'
340: and ppa.payroll_action_id = paa.payroll_action_id
341: and ppa.time_period_id = l_assignment_rec.time_period_id