APPS.HR_PERIODS_OF_SERVICE_API dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 864: FROM pay_element_entry_values_f eev,

860: FOR UPDATE NOWAIT;
861: --
862: CURSOR csr_lock_eev (p_assignment_id NUMBER) IS
863: SELECT eev.element_entry_id
864: FROM pay_element_entry_values_f eev,
865: pay_element_entries_f ele
866: WHERE ele.assignment_id = p_assignment_id
867: AND eev.element_entry_id = ele.element_entry_id
868: FOR UPDATE NOWAIT;

Line 1107: -- UPDATE pay_element_entry_values_f

1103: --
1104: --
1105: -- 115.14 (START)
1106: --
1107: -- UPDATE pay_element_entry_values_f
1108: -- SET effective_end_date = l_new_final_process_date
1109: -- WHERE p_old_final_process_date BETWEEN effective_start_date
1110: -- AND effective_end_date
1111: -- AND element_entry_id IN (SELECT element_entry_id