APPS.HR_PERIODS_OF_SERVICE_API dependencies on PAY_COST_ALLOCATIONS_F

Line 846: FROM pay_cost_allocations_f csa

842: AND asg.effective_end_date = p_old_final_process_date;
843: --
844: CURSOR csr_lock_csa (p_assignment_id NUMBER) IS
845: SELECT NULL
846: FROM pay_cost_allocations_f csa
847: WHERE csa.assignment_id = csr_lock_csa.p_assignment_id
848: FOR UPDATE NOWAIT;
849: --
850: CURSOR csr_lock_alu (p_assignment_id NUMBER) IS

Line 1074: UPDATE pay_cost_allocations_f

1070: AND effective_start_date = l_effective_start_date
1071: AND effective_end_date = l_effective_end_date
1072: AND object_version_number = l_object_version_number;
1073: --
1074: UPDATE pay_cost_allocations_f
1075: SET effective_end_date = l_new_final_process_date
1076: WHERE assignment_id = l_assignment_id
1077: AND p_old_final_process_date BETWEEN effective_start_date
1078: AND effective_end_date;