DBA Data[Home] [Help]

APPS.PAY_JP_PAYSLIP_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 831: SELECT pay_assignment_actions_s.NEXTVAL

827: -- Even if multiple prepayment processes match the condition of archiving, only single assignment
828: -- action for archiving process should be created.
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