DBA Data[Home] [Help]

APPS.PAY_IE_P45_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 3891: SELECT pay_assignment_actions_s.NEXTVAL

3887: THEN
3888:
3889: hr_utility.set_location('Different Person '|| csr_rec.person_id ,22);
3890:
3891: SELECT pay_assignment_actions_s.NEXTVAL
3892: INTO l_actid
3893: FROM dual;
3894:
3895: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION

Line 4233: SELECT pay_assignment_actions_s.NEXTVAL

4229: IF (l_record_count = 0 AND csr_rec.assignment_id = l_assignment_id)
4230: THEN
4231: -- Create child P45 action to lock the child payroll process child action
4232: -- To avoid data corruption 4468864
4233: SELECT pay_assignment_actions_s.NEXTVAL
4234: INTO l_actid
4235: FROM dual;
4236:
4237: hr_nonrun_asact.insact(