DBA Data[Home] [Help]

APPS.PAY_GB_P11D_ARCHIVE_SS dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 885: SELECT pay_assignment_actions_s.NEXTVAL

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

Line 917: SELECT pay_assignment_actions_s.NEXTVAL

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

Line 950: SELECT pay_assignment_actions_s.NEXTVAL

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