DBA Data[Home] [Help]

APPS.AP_ACCOUNTING_PAY_PKG dependencies on XLA_EVENTS_GT

Line 37: FROM XLA_Events_GT

33: Event_Number,
34: Event_Status_Code,
35: Entity_Code,
36: Source_ID_Int_1
37: FROM XLA_Events_GT
38: WHERE (Entity_Code = 'AP_PAYMENTS'
39: OR Event_Type_Code IN ('PREPAYMENT APPLIED',
40: 'PREPAYMENT UNAPPLIED',
41: 'PREPAYMENT APPLICATION ADJ'))

Line 290: FROM XLA_Events_GT

286: -- Bug 5098657. Added the where condition for both the delete statements
287: DELETE FROM AP_Payment_Hist_Dists
288: WHERE Accounting_Event_ID IN
289: (SELECT Event_ID
290: FROM XLA_Events_GT
291: WHERE Entity_Code = 'AP_PAYMENTS');
292:
293: DELETE FROM AP_Prepay_App_Dists
294: WHERE Accounting_Event_ID IN

Line 296: FROM XLA_Events_GT

292:
293: DELETE FROM AP_Prepay_App_Dists
294: WHERE Accounting_Event_ID IN
295: (SELECT Event_ID
296: FROM XLA_Events_GT
297: WHERE Event_Type_Code IN ('PREPAYMENT APPLICATION ADJ'));
298:
299:
300: EXCEPTION