APPS.PAY_FR_SETTLEMENT dependencies on PAY_PAYROLL_ACTIONS

Line 12: , pay_payroll_actions pa

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
16: and aa.payroll_action_id = pa.payroll_action_id

Line 21: from pay_payroll_actions pa1

17: and pa.effective_date
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

Line 223: , pay_payroll_actions pa

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
227: and aa.payroll_action_id = pa.payroll_action_id

Line 232: from pay_payroll_actions pa1

228: and pa.effective_date
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