APPS.HR_DELETE dependencies on PAY_DATETRACKED_EVENTS

Line 222: and pay_datetracked_events.

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.
224: Changed SQL code to use exists rather than
225: selecting every row from the db. This makes
226: a significant performance gain.

Line 1885: DELETE FROM pay_datetracked_events

1881: --
1882: DELETE FROM ben_benefit_contributions_f bbc
1883: WHERE bbc.business_group_id = p_business_group_id;
1884: --
1885: DELETE FROM pay_datetracked_events
1886: WHERE business_group_id = p_business_group_id;
1887: hr_utility.set_location(l_proc, 140);
1888: --
1889: DELETE FROM pay_event_groups