1872: --
1873: --
1874: hr_utility.set_location(l_proc,1);
1875: --
1876: DELETE FROM pay_assignment_link_usages_f alu
1877: WHERE alu.assignment_id = p_assignment_id
1878: AND alu.effective_start_date > p_term_date;
1879: --
1880: if sql%found then
1882: end if;
1883: --
1884: hr_utility.set_location(l_proc,2);
1885: --
1886: UPDATE pay_assignment_link_usages_f alu
1887: SET alu.effective_end_date = p_term_date
1888: WHERE alu.assignment_id = p_assignment_id
1889: AND alu.effective_end_date > p_term_date;
1890: --