APPS.HR_PERSON_DELETE dependencies on PAY_US_EMP_STATE_TAX_RULES_F

Line 158: pay_us_emp_state_tax_rules_f

154: 115.22 06-AUG-2001 rvydyana 1844844 Added per_qualifications to the delete
155: list.
156: 115.23 22-FEB-2002 rmonge 1686922 Added code to delete tax records from
157: pay_us_emp_fed_tax_rules_f
158: pay_us_emp_state_tax_rules_f
159: pay_us_emp_county_tax_rules_f
160: pay_us_emp_city_tax_rules_f
161: The deletion process was leaving
162: orphan rows.

Line 2454: Delete pay_us_emp_state_tax_rules_f pest

2450: begin
2451:
2452: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 40);
2453:
2454: Delete pay_us_emp_state_tax_rules_f pest
2455: Where pest.assignment_id in (
2456: select ass.assignment_id
2457: from per_assignments_f ass
2458: where ass.person_id = p_person_id );