DBA Data[Home] [Help]

APPS.PAY_CA_UPDATE_TAX_REC_PKG dependencies on PAY_CA_EMP_FED_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 42: UPDATE pay_ca_emp_fed_tax_info_f peft

38: p_assignment_id );
39: --
40: hr_utility.set_location
41: ('pay_ca_update_tax_rec_pkg.reverse_term_emp_tax_records',5);
42: UPDATE pay_ca_emp_fed_tax_info_f peft
43: SET peft.effective_end_date =
44: to_date('31/12/4712','DD/MM/YYYY')
45: WHERE peft.assignment_id = p_assignment_id
46: AND peft.effective_end_date = p_process_date;