APPS.PAY_US_UPDATE_TAX_REC_PKG dependencies on PAY_US_EMP_STATE_TAX_RULES_F

Line 80: UPDATE pay_us_emp_state_tax_rules_f pest

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);
80: UPDATE pay_us_emp_state_tax_rules_f pest
81: SET pest.effective_end_date = l_new_end_date
82: WHERE pest.assignment_id = p_assignment_id
83: AND l_ef_date
84: BETWEEN pest.effective_start_date AND pest.effective_end_date;

Line 86: DELETE pay_us_emp_state_tax_rules_f pest

82: WHERE pest.assignment_id = p_assignment_id
83: AND l_ef_date
84: BETWEEN pest.effective_start_date AND pest.effective_end_date;
85: --
86: DELETE pay_us_emp_state_tax_rules_f pest
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);

Line 176: UPDATE pay_us_emp_state_tax_rules_f pest

172: AND peft.effective_end_date = p_process_date;
173: --
174: hr_utility.set_location
175: ('pay_us_update_tax_rec_pkg.reverse_term_emp_tax_records',6);
176: UPDATE pay_us_emp_state_tax_rules_f pest
177: SET pest.effective_end_date =
178: to_date('31/12/4712','DD/MM/YYYY')
179: WHERE pest.assignment_id = p_assignment_id
180: AND pest.effective_end_date = p_process_date;