DBA Data[Home] [Help]

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 2482: Delete pay_us_emp_city_tax_rules_f pecit

2478: begin
2479:
2480: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 42);
2481:
2482: Delete pay_us_emp_city_tax_rules_f pecit
2483: Where pecit.assignment_id in (
2484: select ass.assignment_id
2485: from per_assignments_f ass
2486: where ass.person_id = p_person_id );