APPS.PAY_US_UPDATE_TAX_REC_PKG dependencies on PAY_US_EMP_CITY_TAX_RULES_F

Line 102: UPDATE pay_us_emp_city_tax_rules_f pecit

98: WHERE pect.assignment_id = p_assignment_id
99: AND pect.effective_start_date > l_ef_date;
100: --
101: hr_utility.set_location(l_proc,9);
102: UPDATE pay_us_emp_city_tax_rules_f pecit
103: SET pecit.effective_end_date = l_new_end_date
104: WHERE pecit.assignment_id = p_assignment_id
105: AND l_ef_date
106: BETWEEN pecit.effective_start_date AND pecit.effective_end_date;

Line 108: DELETE pay_us_emp_city_tax_rules_f pecit

104: WHERE pecit.assignment_id = p_assignment_id
105: AND l_ef_date
106: BETWEEN pecit.effective_start_date AND pecit.effective_end_date;
107: --
108: DELETE pay_us_emp_city_tax_rules_f pecit
109: WHERE pecit.assignment_id = p_assignment_id
110: AND pecit.effective_start_date > l_ef_date;
111: --
112: end if; -- maintaining tax records

Line 192: UPDATE pay_us_emp_city_tax_rules_f pecit

188: AND pect.effective_end_date = p_process_date;
189: --
190: hr_utility.set_location
191: ('pay_us_update_tax_rec_pkg.reverse_term_emp_tax_records',8);
192: UPDATE pay_us_emp_city_tax_rules_f pecit
193: SET pecit.effective_end_date =
194: to_date('31/12/4712','DD/MM/YYYY')
195: WHERE pecit.assignment_id = p_assignment_id
196: AND pecit.effective_end_date = p_process_date;