13: l_proc VARCHAR2(100) := 'pay_us_update_tax_rec_pkg.terminate_emp_tax_records';
14:
15: CURSOR csr_tax_defaulting(p_asg_id NUMBER) is
16: select min(ftr.effective_start_date)
17: from pay_us_emp_fed_tax_rules_f ftr
18: where ftr.assignment_id = p_asg_id;
19:
20:
21: CURSOR csr_tax_entries(p_asg_id NUMBER,p_ef_date DATE) is
65:
66: if hr_general.chk_maintain_tax_records = 'Y' then
67:
68: hr_utility.set_location(l_proc,6);
69: UPDATE pay_us_emp_fed_tax_rules_f peft
70: SET peft.effective_end_date = l_new_end_date
71: WHERE peft.assignment_id = p_assignment_id
72: AND l_ef_date
73: BETWEEN peft.effective_start_date AND peft.effective_end_date;
71: WHERE peft.assignment_id = p_assignment_id
72: AND l_ef_date
73: BETWEEN peft.effective_start_date AND peft.effective_end_date;
74: --
75: DELETE pay_us_emp_fed_tax_rules_f peft
76: WHERE peft.assignment_id = p_assignment_id
77: AND peft.effective_start_date > l_ef_date;
78: --
79: hr_utility.set_location(l_proc,7);
164: p_assignment_id );
165: --
166: hr_utility.set_location
167: ('pay_us_update_tax_rec_pkg.reverse_term_emp_tax_records',5);
168: UPDATE pay_us_emp_fed_tax_rules_f peft
169: SET peft.effective_end_date =
170: to_date('31/12/4712','DD/MM/YYYY')
171: WHERE peft.assignment_id = p_assignment_id
172: AND peft.effective_end_date = p_process_date;