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_IN_BONUS_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 90: ,pay_payroll_actions ppa1

86: CURSOR c_assign_action(p_fy_start_date DATE) IS
87: select paa1.assignment_action_id
88: ,ppa1.date_earned
89: from pay_assignment_actions paa1
90: ,pay_payroll_actions ppa1
91: where ppa1.payroll_action_id = paa1.payroll_action_id
92: and assignment_action_id = (SELECT max(paa.assignment_action_id)
93: FROM pay_assignment_actions paa
94: ,pay_payroll_actions ppa

Line 94: ,pay_payroll_actions ppa

90: ,pay_payroll_actions ppa1
91: where ppa1.payroll_action_id = paa1.payroll_action_id
92: and assignment_action_id = (SELECT max(paa.assignment_action_id)
93: FROM pay_assignment_actions paa
94: ,pay_payroll_actions ppa
95: WHERE paa.assignment_id = p_assignment_id
96: AND ppa.payroll_action_id = paa.payroll_action_id
97: AND ppa.date_earned BETWEEN p_fy_start_date
98: AND p_date_earned