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.

[Home] [Help]

APPS.PAY_SG_IRAS_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 98: select pay_assignment_actions_s.nextval

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

Line 241: select pay_assignment_actions_s.nextval

237: ----------------------------------------------------------------------------
238: -- Cursor Next Assignment Action
239: ----------------------------------------------------------------------------
240: cursor next_action_id is
241: select pay_assignment_actions_s.nextval
242: from dual;
243: ----------------------------------------------------------------------------
244: -- Cursor Process_assignments
245: -- Bug: 3404526 - Added max(assignment_id) to pick the latest assignment in case of Normal rehire.