eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FR_SETTLEMENT dependencies on PAY_ACTION_INFORMATION

Line 10: from pay_action_information actinfo

6: Cursor c_get_payment(p_assignment_id number
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

Line 23: , pay_action_information actinfo1

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
27: and aa1.payroll_action_id = pa1.payroll_action_id

Line 221: from pay_action_information actinfo

217: --
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