DBA Data[Home] [Help]

APPS.HR_DELETE dependencies on PAY_DATED_TABLES

Line 220: 115.14 28-MAR-01 N.Bristow Deleting from pay_dated_tables,

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.
224: Changed SQL code to use exists rather than

Line 1901: DELETE FROM pay_dated_tables

1897: DELETE FROM pay_event_updates
1898: WHERE business_group_id = p_business_group_id;
1899: hr_utility.set_location(l_proc, 160);
1900: --
1901: DELETE FROM pay_dated_tables
1902: WHERE business_group_id = p_business_group_id;
1903: --
1904: hr_utility.set_location('Leaving: '||l_proc, 200);
1905: end delete_pay_misc;