DBA Data[Home] [Help]

APPS.PAY_CA_UPDATE_TAX_REC_PKG dependencies on HR_UTILITY

Line 37: hr_utility.trace('Entered reverse_term_emp_tax_records for assign ' ||

33: ,p_process_date DATE)
34: IS
35: BEGIN
36: --
37: hr_utility.trace('Entered reverse_term_emp_tax_records for assign ' ||
38: p_assignment_id );
39: --
40: hr_utility.set_location
41: ('pay_ca_update_tax_rec_pkg.reverse_term_emp_tax_records',5);

Line 40: hr_utility.set_location

36: --
37: hr_utility.trace('Entered reverse_term_emp_tax_records for assign ' ||
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')

Line 48: hr_utility.set_location

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;
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')