APPS.HR_PERIODS_OF_SERVICE_API dependencies on PAY_COST_ALLOCATIONS_F

Line 856: FROM pay_cost_allocations_f csa

852: AND asg.effective_end_date = p_old_final_process_date;
853: --
854: CURSOR csr_lock_csa (p_assignment_id NUMBER) IS
855: SELECT NULL
856: FROM pay_cost_allocations_f csa
857: WHERE csa.assignment_id = csr_lock_csa.p_assignment_id
858: FOR UPDATE NOWAIT;
859: --
860: CURSOR csr_lock_alu (p_assignment_id NUMBER) IS

Line 1383: UPDATE pay_cost_allocations_f

1379: CLOSE csr_get_ast_status_details;
1380:
1381: hr_utility.set_location(l_proc, 88);
1382: --
1383: UPDATE pay_cost_allocations_f
1384: SET effective_end_date = l_new_final_process_date
1385: WHERE assignment_id = l_assignment_id
1386: AND p_old_final_process_date BETWEEN effective_start_date
1387: AND effective_end_date;