APPS.PAY_SG_IRAS_ARCHIVE dependencies on DUAL

Line 99: from dual;

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
103: from pay_action_information pai

Line 242: from dual;

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.
246: -- Bug#3614563 Removed the Business Group id check from inner query to imporove the performence.