APPS.PAY_IE_P45_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 3122: SELECT pay_assignment_actions_s.NEXTVAL

3118: IF (l_person_id <> csr_rec.person_id) THEN
3119:
3120: hr_utility.set_location('Different Person '|| csr_rec.person_id ,22);
3121:
3122: SELECT pay_assignment_actions_s.NEXTVAL
3123: INTO l_actid
3124: FROM dual;
3125:
3126: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION

Line 3401: SELECT pay_assignment_actions_s.NEXTVAL

3397: IF (l_record_count = 0 AND csr_rec.assignment_id = l_assignment_id)
3398: THEN
3399: -- Create child P45 action to lock the child payroll process child action
3400: -- To avoid data corruption 4468864
3401: SELECT pay_assignment_actions_s.NEXTVAL
3402: INTO l_actid
3403: FROM dual;
3404:
3405: hr_nonrun_asact.insact(