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

Line 137: , pay_payroll_actions ppa

133: , c_effective_date in date
134: ) is
135: select /*+ORDERED*/ to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
136: from pay_assignment_actions paa
137: , pay_payroll_actions ppa
138: where paa.assignment_id = c_assignment_id
139: and ppa.payroll_action_id = paa.payroll_action_id
140: and ppa.effective_date <= c_effective_date
141: and ppa.effective_date >= trunc(c_effective_date,'MM')

Line 309: , pay_payroll_actions ppa

305: , c_effective_date in date
306: ) is
307: select /*+ORDERED*/ to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
308: from pay_assignment_actions paa
309: , pay_payroll_actions ppa
310: where paa.assignment_id = c_assignment_id
311: and ppa.payroll_action_id = paa.payroll_action_id
312: and ppa.effective_date <= c_effective_date
313: and ppa.effective_date >= trunc(c_effective_date,'MM')