APPS.PAY_CA_UPDATE_TAX_REC_PKG dependencies on PAY_CA_EMP_PROV_TAX_INFO_F

Line 21: pay_ca_emp_fed_tax_info_f, pay_ca_emp_prov_tax_info_f.

17: need to be modified to update the Effective End Date to
18: the end of time.
19:
20: The following two tables are updated:
21: pay_ca_emp_fed_tax_info_f, pay_ca_emp_prov_tax_info_f.
22:
23: Change List:
24: ------------
25:

Line 50: UPDATE pay_ca_emp_prov_tax_info_f pest

46: AND peft.effective_end_date = p_process_date;
47: --
48: hr_utility.set_location
49: ('pay_ca_update_tax_rec_pkg.reverse_term_emp_tax_records',6);
50: UPDATE pay_ca_emp_prov_tax_info_f pest
51: SET pest.effective_end_date =
52: to_date('31/12/4712','DD/MM/YYYY')
53: WHERE pest.assignment_id = p_assignment_id
54: AND pest.effective_end_date = p_process_date;