APPS.HR_PERSON_DELETE dependencies on PAY_US_EMP_CITY_TAX_RULES_F

Line 160: pay_us_emp_city_tax_rules_f

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.
163: 115.24 02-DEC-2002 eumenyio added the nocopy compiler and also
164: the WHENEVER OSERROR EXIT FAILURE

Line 2553: Delete pay_us_emp_city_tax_rules_f pecit

2549: begin
2550:
2551: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 42);
2552:
2553: Delete pay_us_emp_city_tax_rules_f pecit
2554: Where pecit.assignment_id in (
2555: select ass.assignment_id
2556: from per_assignments_f ass
2557: where ass.person_id = p_person_id );