APPS.PAY_PAYROLLS_F_PKG dependencies on DUAL

Line 201: from sys.dual;

197: -- select the next sequence value for the soft coding keyflex.
198: begin
199: select hr_soft_coding_keyflex_s.nextval
200: into v_soft_coding_keyflex_id
201: from sys.dual;
202: exception
203: when NO_DATA_FOUND then
204: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
205: hr_utility.set_message_token('PROCEDURE',

Line 1557: CURSOR C2 IS SELECT pay_payrolls_s.nextval FROM sys.dual;

1553: --
1554: CURSOR C IS SELECT rowid FROM PAY_ALL_PAYROLLS_F
1555: WHERE payroll_id = X_Payroll_Id;
1556: --
1557: CURSOR C2 IS SELECT pay_payrolls_s.nextval FROM sys.dual;
1558: --
1559: l_midpoint_offset number := 0 ;
1560: --
1561: BEGIN