DBA Data[Home] [Help]

APPS.HR_DELETE dependencies on PAY_EVENT_PROCEDURES

Line 227: 115.16 02-JUL-01 N.Bristow Deleting from pay_event_procedures now.

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.
227: 115.16 02-JUL-01 N.Bristow Deleting from pay_event_procedures now.
228: 115.17 04-Sep-00 dsaxby Changes for purge (1682940).
229: - Added deletes for pay_us_asg_reporting,
230: pay_balance_sets, pay_balance_set_members.
231: - Update the secondary_status for any purge

Line 1893: DELETE FROM pay_event_procedures

1889: DELETE FROM pay_event_groups
1890: WHERE business_group_id = p_business_group_id;
1891: hr_utility.set_location(l_proc, 150);
1892: --
1893: DELETE FROM pay_event_procedures
1894: WHERE business_group_id = p_business_group_id;
1895: hr_utility.set_location(l_proc, 155);
1896: --
1897: DELETE FROM pay_event_updates