APPS.HR_PERIODS_OF_SERVICE_API dependencies on PAY_ASSIGNMENT_LINK_USAGES_F

Line 862: FROM pay_assignment_link_usages_f alu

858: FOR UPDATE NOWAIT;
859: --
860: CURSOR csr_lock_alu (p_assignment_id NUMBER) IS
861: SELECT NULL
862: FROM pay_assignment_link_usages_f alu
863: WHERE alu.assignment_id = csr_lock_alu.p_assignment_id
864: FOR UPDATE NOWAIT;
865: --
866: CURSOR csr_lock_ele (p_assignment_id NUMBER) IS

Line 1401: UPDATE pay_assignment_link_usages_f

1397: WHERE assignment_id = l_assignment_id
1398: AND p_old_final_process_date BETWEEN effective_start_date
1399: AND effective_end_date;
1400: --
1401: UPDATE pay_assignment_link_usages_f
1402: SET effective_end_date = l_new_final_process_date
1403: WHERE assignment_id = l_assignment_id
1404: AND p_old_final_process_date BETWEEN effective_start_date
1405: AND effective_end_date;