APPS.HR_PERIODS_OF_SERVICE_API dependencies on PAY_ELEMENT_ENTRIES_F

Line 858: FROM pay_element_entries_f ele

854: FOR UPDATE NOWAIT;
855: --
856: CURSOR csr_lock_ele (p_assignment_id NUMBER) IS
857: SELECT NULL
858: FROM pay_element_entries_f ele
859: WHERE ele.assignment_id = csr_lock_ele.p_assignment_id
860: FOR UPDATE NOWAIT;
861: --
862: CURSOR csr_lock_eev (p_assignment_id NUMBER) IS

Line 865: pay_element_entries_f ele

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

Line 1112: -- FROM pay_element_entries_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
1112: -- FROM pay_element_entries_f
1113: -- WHERE assignment_id = l_assignment_id);
1114: --
1115: -- UPDATE pay_element_entries_f
1116: -- SET effective_end_date = l_new_final_process_date

Line 1115: -- UPDATE pay_element_entries_f

1111: -- AND element_entry_id IN (SELECT element_entry_id
1112: -- FROM pay_element_entries_f
1113: -- WHERE assignment_id = l_assignment_id);
1114: --
1115: -- UPDATE pay_element_entries_f
1116: -- SET effective_end_date = l_new_final_process_date
1117: -- WHERE assignment_id = l_assignment_id
1118: -- AND p_old_final_process_date BETWEEN effective_start_date
1119: -- AND effective_end_date;