APPS.PER_ES_SS_REP_ARCHIVE_PKG dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 641: SELECT pay_assignment_actions_s.NEXTVAL

637: FETCH csr_filter_legal_employer INTO l_assignment_id,l_legal_employer;
638:
639: IF csr_filter_legal_employer%FOUND THEN
640:
641: SELECT pay_assignment_actions_s.NEXTVAL
642: INTO l_actid
643: FROM dual;
644:
645: hr_nonrun_asact.insact(l_actid

Line 1536: SELECT pay_assignment_actions_s.NEXTVAL

1532: FOR qualifying_assignments IN csr_get_assignments (g_arch_payroll_action_id) LOOP
1533: --
1534: -- create a new action and lock the fetched one
1535: --
1536: SELECT pay_assignment_actions_s.NEXTVAL
1537: INTO l_actid
1538: FROM dual;
1539: --
1540: hr_nonrun_asact.insact(l_actid