DBA Data[Home] [Help]

APPS.PAY_GB_PAYSLIP_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 1923: SELECT pay_assignment_actions_s.NEXTVAL

1919: FOR csr_rec IN csr_range_pre_assignments(pactid, l_payroll_id, l_consolidation_set)
1920: LOOP
1921: IF l_prepay_action_id <> csr_rec.prepaid_action_id THEN
1922: --
1923: SELECT pay_assignment_actions_s.NEXTVAL
1924: INTO l_actid
1925: FROM dual;
1926: --
1927: -- Create the archive assignment action for master action

Line 1960: SELECT pay_assignment_actions_s.NEXTVAL

1956: IF l_prepay_action_id <> csr_rec.prepaid_action_id
1957:
1958: THEN
1959:
1960: SELECT pay_assignment_actions_s.NEXTVAL
1961: INTO l_actid
1962: FROM dual;
1963:
1964: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION

Line 2165: SELECT pay_assignment_actions_s.NEXTVAL

2161: csr_rec.effective_date)
2162:
2163: LOOP
2164: -- create additional archive assignment actions and interlocks
2165: SELECT pay_assignment_actions_s.NEXTVAL
2166: INTO l_actid
2167: FROM dual;
2168:
2169: hr_utility.set_location('csr_child_rec.run_type = ' ||