DBA Data[Home] [Help]

APPS.AP_ACCTG_PREPAY_DIST_PKG dependencies on XLA_EVENTS

Line 52: XLA_Events XE

48: APH.Accounting_Date,
49: APH.Invoice_Adjustment_Event_ID,
50: APH.Related_Prepay_App_Event_ID
51: FROM AP_Prepay_History_All APH,
52: XLA_Events XE
53: WHERE APH.Invoice_ID = P_Invoice_ID
54: --AND APH.Accounting_Event_ID IS NULL
55: AND nvl(APH.Posted_flag, 'N') <> 'Y'
56: AND XE.application_id(+) = 200

Line 170: FROM xla_events

166: AND AID.Prepay_Tax_Parent_ID IS NULL -- For tax dists created in R11.5
167: AND NVL(AID.Cancellation_Flag,'N') <> 'Y' -- BUG 6513956
168: -- bug fix 6909150
169: AND NOT EXISTS (SELECT 1
170: FROM xla_events
171: WHERE event_id = AID.accounting_event_id
172: AND event_type_code IN ('INVOICE CANCELLED',
173: 'CREDIT MEMO CANCELLED',
174: 'DEBIT MEMO CANCELLED'))