APPS.HR_DELETE dependencies on HR_ASSIGNMENT_SET_CRITERIA

Line 219: 115.13 31-OCT-00 D.Saxby Fixed deletion of hr_assignment_set_criteria.

215: 115.10 12-JUN-00 N.Bristow Added delete_run_types and now removing
216: process_events and iterative rules.
217: 115.11 03-OCT-00 I.Harding Added delete of job groups
218: 115.12 03-OCT-00 I.Harding Change to above fix.
219: 115.13 31-OCT-00 D.Saxby Fixed deletion of hr_assignment_set_criteria.
220: 115.14 28-MAR-01 N.Bristow Deleting from pay_dated_tables,
221: pay_event_updates, payevent_groups
222: and pay_datetracked_events.
223: 115.15 19-JUN-01 G.Perry Fixed WWBUG 1833930.

Line 1657: DELETE FROM hr_assignment_set_criteria has

1653: WHERE pp.payroll_id = pmu.payroll_id
1654: AND pp.business_group_id = p_business_group_id);
1655: hr_utility.set_location(l_proc,30);
1656: --
1657: DELETE FROM hr_assignment_set_criteria has
1658: WHERE
1659: EXISTS ( SELECT ''
1660: FROM hr_assignment_sets ase
1661: WHERE ase.assignment_set_id = has.assignment_set_id