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_SG_IRAS_ARCHIVE dependencies on DUAL

Line 96: from dual;

92: where payroll_action_id = c_payroll_Action_id;
93: --
94: cursor next_action_id is
95: select pay_assignment_actions_s.nextval
96: from dual;
97: --
98: cursor process_assignments ( c_setup_action_id in pay_payroll_actions.payroll_action_id%type ) is
99: select distinct pai.assignment_id
100: from pay_action_information pai

Line 239: from dual;

235: -- Cursor Next Assignment Action
236: ----------------------------------------------------------------------------
237: cursor next_action_id is
238: select pay_assignment_actions_s.nextval
239: from dual;
240: ----------------------------------------------------------------------------
241: -- Cursor Process_assignments
242: -- Bug: 3404526 - Added max(assignment_id) to pick the latest assignment in case of Normal rehire.
243: -- Bug#3614563 Removed the Business Group id check from inner query to imporove the performence.