DBA Data[Home] [Help]

APPS.PAY_GB_P11D_ARCHIVE_SS dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 886: SELECT pay_assignment_actions_s.NEXTVAL

882: if check_assignment_tax_ref(csr_rec.assignment_id,l_tax_reference,l_benefit_end_date) then
883: if l_prev_assignment_id IS NULL OR l_prev_assignment_id <> csr_rec.assignment_id
884: THEN
885: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
886: SELECT pay_assignment_actions_s.NEXTVAL
887: INTO l_actid
888: FROM DUAL;
889:
890: hr_utility.set_location('Archive assignment Action ', 30);

Line 918: SELECT pay_assignment_actions_s.NEXTVAL

914: if check_assignment_tax_ref(csr_rec.assignment_id,l_tax_reference,l_benefit_end_date) then
915: if l_prev_assignment_id IS NULL OR l_prev_assignment_id <> csr_rec.assignment_id
916: THEN
917: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
918: SELECT pay_assignment_actions_s.NEXTVAL
919: INTO l_actid
920: FROM DUAL;
921:
922: hr_utility.set_location('Archive assignment Action ', 30);

Line 951: SELECT pay_assignment_actions_s.NEXTVAL

947: if check_assignment_tax_ref(csr_rec.assignment_id,l_tax_reference,l_benefit_end_date) then
948: IF l_prev_assignment_id IS NULL OR l_prev_assignment_id <> csr_rec.assignment_id
949: THEN
950: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
951: SELECT pay_assignment_actions_s.NEXTVAL
952: INTO l_actid
953: FROM DUAL;
954: hr_utility.set_location('Archive assignment Action ', 30);
955: hr_nonrun_asact.insact(l_actid, csr_rec.assignment_id, pactid, CHUNK, NULL);