APPS.HR_PERIODS_OF_SERVICE_API dependencies on PAY_ASSIGNMENT_LINK_USAGES_F

Line 852: FROM pay_assignment_link_usages_f alu

848: FOR UPDATE NOWAIT;
849: --
850: CURSOR csr_lock_alu (p_assignment_id NUMBER) IS
851: SELECT NULL
852: FROM pay_assignment_link_usages_f alu
853: WHERE alu.assignment_id = csr_lock_alu.p_assignment_id
854: FOR UPDATE NOWAIT;
855: --
856: CURSOR csr_lock_ele (p_assignment_id NUMBER) IS

Line 1092: UPDATE pay_assignment_link_usages_f

1088: WHERE assignment_id = l_assignment_id
1089: AND p_old_final_process_date BETWEEN effective_start_date
1090: AND effective_end_date;
1091: --
1092: UPDATE pay_assignment_link_usages_f
1093: SET effective_end_date = l_new_final_process_date
1094: WHERE assignment_id = l_assignment_id
1095: AND p_old_final_process_date BETWEEN effective_start_date
1096: AND effective_end_date;