DBA Data[Home] [Help]

APPS.PAY_JP_PAYSLIP_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 830: SELECT pay_assignment_actions_s.NEXTVAL

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