APPS.HR_PERIODS_OF_SERVICE_API dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 874: FROM pay_element_entry_values_f eev,

870: FOR UPDATE NOWAIT;
871: --
872: CURSOR csr_lock_eev (p_assignment_id NUMBER) IS
873: SELECT eev.element_entry_id
874: FROM pay_element_entry_values_f eev,
875: pay_element_entries_f ele
876: WHERE ele.assignment_id = p_assignment_id
877: AND eev.element_entry_id = ele.element_entry_id
878: FOR UPDATE NOWAIT;

Line 1416: -- UPDATE pay_element_entry_values_f

1412: --
1413: --
1414: -- 115.14 (START)
1415: --
1416: -- UPDATE pay_element_entry_values_f
1417: -- SET effective_end_date = l_new_final_process_date
1418: -- WHERE p_old_final_process_date BETWEEN effective_start_date
1419: -- AND effective_end_date
1420: -- AND element_entry_id IN (SELECT element_entry_id