APPS.PAY_JP_PAYSLIP_ARCHIVE dependencies on DUAL

Line 832: FROM dual;

828: --
829: IF (l_prepay_assignment_id is null) or (l_prepay_assignment_id <> l_asg_rec.prepay_assignment_id) THEN
830: SELECT pay_assignment_actions_s.NEXTVAL
831: INTO l_arch_assignment_action_id
832: FROM dual;
833: --
834: -- create an archive assignment action for the master assignment action
835: --
836: hr_utility.trace('inserting into PAY_ASSIGNMENT_ACTIONS');

Line 1019: from dual

1015: IS
1016: l_dummy varchar2(1);
1017: cursor csr_pa_exists is
1018: select 'Y'
1019: from dual
1020: where exists(
1021: select null
1022: from pay_action_information
1023: where action_context_id = p_payroll_action_id