APPS.PAY_GB_PAYSLIP_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 1994: SELECT pay_assignment_actions_s.NEXTVAL

1990: FOR csr_rec IN csr_range_pre_assignments(pactid, l_payroll_id, l_consolidation_set)
1991: LOOP
1992: IF l_prepay_action_id <> csr_rec.prepaid_action_id THEN
1993: --
1994: SELECT pay_assignment_actions_s.NEXTVAL
1995: INTO l_actid
1996: FROM dual;
1997: --
1998: -- Create the archive assignment action for master action

Line 2031: SELECT pay_assignment_actions_s.NEXTVAL

2027: IF l_prepay_action_id <> csr_rec.prepaid_action_id
2028:
2029: THEN
2030:
2031: SELECT pay_assignment_actions_s.NEXTVAL
2032: INTO l_actid
2033: FROM dual;
2034:
2035: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION

Line 2238: SELECT pay_assignment_actions_s.NEXTVAL

2234: csr_rec.effective_date)
2235:
2236: LOOP
2237: -- create additional archive assignment actions and interlocks
2238: SELECT pay_assignment_actions_s.NEXTVAL
2239: INTO l_actid
2240: FROM dual;
2241:
2242: hr_utility.set_location('csr_child_rec.run_type = ' ||