DBA Data[Home] [Help]

APPS.PAY_IE_LEGISLATIVE_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 2309: SELECT pay_assignment_actions_s.NEXTVAL

2305: IF l_prepay_action_id <> csr_rec.prepaid_action_id
2306:
2307: THEN
2308:
2309: SELECT pay_assignment_actions_s.NEXTVAL
2310: INTO l_actid
2311: FROM dual;
2312:
2313: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION

Line 2347: SELECT pay_assignment_actions_s.NEXTVAL

2343: IF l_prepay_action_id <> csr_rec.prepaid_action_id
2344:
2345: THEN
2346:
2347: SELECT pay_assignment_actions_s.NEXTVAL
2348: INTO l_actid
2349: FROM dual;
2350:
2351: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION

Line 2614: SELECT pay_assignment_actions_s.NEXTVAL

2610: LOOP
2611:
2612: -- create additional archive assignment actions and interlocks
2613:
2614: SELECT pay_assignment_actions_s.NEXTVAL
2615: INTO l_actid
2616: FROM dual;
2617:
2618: hr_utility.set_location('csr_child_rec.run_type = ' || csr_child_rec.run_type,30);