APPS.HR_PERIODS_OF_SERVICE_API dependencies on PAY_ELEMENT_ENTRIES_F

Line 868: FROM pay_element_entries_f ele

864: FOR UPDATE NOWAIT;
865: --
866: CURSOR csr_lock_ele (p_assignment_id NUMBER) IS
867: SELECT NULL
868: FROM pay_element_entries_f ele
869: WHERE ele.assignment_id = csr_lock_ele.p_assignment_id
870: FOR UPDATE NOWAIT;
871: --
872: CURSOR csr_lock_eev (p_assignment_id NUMBER) IS

Line 875: pay_element_entries_f ele

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;
879: --

Line 1421: -- FROM pay_element_entries_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
1421: -- FROM pay_element_entries_f
1422: -- WHERE assignment_id = l_assignment_id);
1423: --
1424: -- UPDATE pay_element_entries_f
1425: -- SET effective_end_date = l_new_final_process_date

Line 1424: -- UPDATE pay_element_entries_f

1420: -- AND element_entry_id IN (SELECT element_entry_id
1421: -- FROM pay_element_entries_f
1422: -- WHERE assignment_id = l_assignment_id);
1423: --
1424: -- UPDATE pay_element_entries_f
1425: -- SET effective_end_date = l_new_final_process_date
1426: -- WHERE assignment_id = l_assignment_id
1427: -- AND p_old_final_process_date BETWEEN effective_start_date
1428: -- AND effective_end_date;