APPS.PAY_FR_SETTLEMENT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 11: , pay_assignment_actions aa

7: ,p_last_day_paid date) is
8:
9: Select sum(actinfo.action_information12) total_pay
10: from pay_action_information actinfo
11: , pay_assignment_actions aa
12: , pay_payroll_actions pa
13: where actinfo.action_information_category = 'FR_SOE_EE_TOTALS'
14: and actinfo.action_context_id = aa.assignment_action_id
15: and aa.assignment_id = p_assignment_id

Line 22: , pay_assignment_actions aa1

18: between trunc(p_last_day_paid,'MM') and last_day(p_last_day_paid)
19: and pa.payroll_action_id =
20: (select max(pa1.payroll_action_id)
21: from pay_payroll_actions pa1
22: , pay_assignment_actions aa1
23: , pay_action_information actinfo1
24: where actinfo1.action_information_category = 'FR_SOE_EE_TOTALS'
25: and actinfo1.action_context_id = aa.assignment_action_id
26: and aa1.assignment_id = p_assignment_id

Line 222: , pay_assignment_actions aa

218: cursor c_get_payment(l_assignment_id number
219: ,p_last_day_paid date) is
220: Select sum(actinfo.action_information12) total_pay
221: from pay_action_information actinfo
222: , pay_assignment_actions aa
223: , pay_payroll_actions pa
224: where actinfo.action_information_category = 'FR_SOE_EE_TOTALS'
225: and actinfo.action_context_id = aa.assignment_action_id
226: and aa.assignment_id = l_assignment_id

Line 233: , pay_assignment_actions aa1

229: between trunc(p_last_day_paid,'MM') and last_day(p_last_day_paid)
230: and pa.effective_date =
231: (select max(pa1.effective_date)
232: from pay_payroll_actions pa1
233: , pay_assignment_actions aa1
234: where aa1.assignment_id = l_assignment_id
235: and aa1.payroll_action_id = pa1.payroll_action_id
236: and pa1.effective_date
237: between trunc(p_last_day_paid,'MM') and last_day(p_last_day_paid)