APPS.HR_DELETE dependencies on PAY_US_ASG_REPORTING

Line 229: - Added deletes for pay_us_asg_reporting,

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
232: assignment actions before attempting to
233: call rollback_payroll_action procedure.

Line 930: DELETE FROM pay_us_asg_reporting uar

926: FROM per_assignments_f pa
927: WHERE pa.assignment_id = pog.source_id
928: AND pa.business_group_id = p_business_group_id);
929: --
930: DELETE FROM pay_us_asg_reporting uar
931: WHERE
932: EXISTS
933: (SELECT ''
934: FROM per_assignments_f pa