APPS.HR_ELEMENT_LINKS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 861: delete from pay_element_entry_values_f

857: begin
858: --
859: if p_delete_mode = 'ZAP' then
860: --
861: delete from pay_element_entry_values_f
862: where element_entry_id = p_element_entry_id;
863: --
864: elsif p_delete_mode = 'DELETE' then
865: --

Line 870: delete from pay_element_entry_values_f

866: --
867: hr_utility.set_location('hr_element_links.entry_values', 1);
868: --
869: -- delete all future records
870: delete from pay_element_entry_values_f
871: where element_entry_id = p_element_entry_id
872: and effective_start_date > p_val_session_date;
873: --
874: -- update current records so that the end date is the session date

Line 875: update pay_element_entry_values_f

871: where element_entry_id = p_element_entry_id
872: and effective_start_date > p_val_session_date;
873: --
874: -- update current records so that the end date is the session date
875: update pay_element_entry_values_f
876: set effective_end_date = p_val_session_date
877: where element_entry_id = p_element_entry_id
878: and p_val_session_date between
879: effective_start_date and effective_end_date;