87: WHERE pest.assignment_id = p_assignment_id
88: AND pest.effective_start_date > l_ef_date;
89: --
90: hr_utility.set_location(l_proc,8);
91: UPDATE pay_us_emp_county_tax_rules_f pect
92: SET pect.effective_end_date = l_new_end_date
93: WHERE pect.assignment_id = p_assignment_id
94: AND l_ef_date
95: BETWEEN pect.effective_start_date AND pect.effective_end_date;
93: WHERE pect.assignment_id = p_assignment_id
94: AND l_ef_date
95: BETWEEN pect.effective_start_date AND pect.effective_end_date;
96: --
97: DELETE pay_us_emp_county_tax_rules_f pect
98: WHERE pect.assignment_id = p_assignment_id
99: AND pect.effective_start_date > l_ef_date;
100: --
101: hr_utility.set_location(l_proc,9);
180: AND pest.effective_end_date = p_process_date;
181: --
182: hr_utility.set_location
183: ('pay_us_update_tax_rec_pkg.reverse_term_emp_tax_records',7);
184: UPDATE pay_us_emp_county_tax_rules_f pect
185: SET pect.effective_end_date =
186: to_date('31/12/4712','DD/MM/YYYY')
187: WHERE pect.assignment_id = p_assignment_id
188: AND pect.effective_end_date = p_process_date;