APPS.PAY_JP_PAYSLIP_ARCHIVE dependencies on DUAL

Line 833: FROM dual;

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

Line 1020: from dual

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