DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_DPSA dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 630: SELECT pay_assignment_actions_s.NEXTVAL

626: LOOP
627: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id
628: AND l_prev_person_id <> rec_prepaid_assignments.person_id THEN
629:
630: SELECT pay_assignment_actions_s.NEXTVAL
631: INTO l_actid
632: FROM dual;
633:
634: -- Create the archive assignment action

Line 663: SELECT pay_assignment_actions_s.NEXTVAL

659: LOOP
660: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id
661: AND l_prev_person_id <> rec_prepaid_assignments.person_id THEN
662:
663: SELECT pay_assignment_actions_s.NEXTVAL
664: INTO l_actid
665: FROM dual;
666:
667: -- Create the archive assignment action