APPS.HR_ELEMENT_LINKS dependencies on PAY_ASSIGNMENT_LINK_USAGES_F

Line 953: delete from pay_assignment_link_usages_f

949: --
950: delete from pay_element_entries_f
951: where element_link_id = p_element_link_id;
952: --
953: delete from pay_assignment_link_usages_f
954: where element_link_id = p_element_link_id;
955: --
956: elsif p_delete_mode = 'DELETE' then
957: --

Line 992: delete from pay_assignment_link_usages_f

988: --
989: hr_utility.set_location('hr_element_links.del_3p_element_link', 4);
990: --
991: -- delete all future records
992: delete from pay_assignment_link_usages_f
993: where element_link_id = p_element_link_id
994: and effective_start_date > p_val_session_date;
995: --
996: -- update current records so that the end date is the session date

Line 997: update pay_assignment_link_usages_f

993: where element_link_id = p_element_link_id
994: and effective_start_date > p_val_session_date;
995: --
996: -- update current records so that the end date is the session date
997: update pay_assignment_link_usages_f
998: set effective_end_date = p_val_session_date
999: where element_link_id = p_element_link_id
1000: and p_val_session_date between
1001: effective_start_date and effective_end_date;

Line 1048: delete from pay_assignment_link_usages_f

1044: --
1045: -- If we are to do 'NEXT_CHANGE_DELETE' on the ALUs we need to delete all ALUs
1046: -- and re_insert them.
1047: --
1048: delete from pay_assignment_link_usages_f
1049: where element_link_id = p_element_link_id;
1050: --
1051: select min(effective_start_date), greatest(max(effective_end_date),p_val_end_date)
1052: into v_alu_start_date, v_alu_end_date