DBA Data[Home] [Help]

APPS.AP_ACCTG_PREPAY_DIST_PKG dependencies on XLA_EVENTS

Line 320: xla_events evnt,

316:
317: CURSOR c_sum_per_event(p_acct_event_id NUMBER) IS
318: SELECT SUM(amount), count(1)
319: FROM ap_invoice_distributions_all aid,
320: xla_events evnt,
321: xla_ae_headers xah,
322: ap_system_parameters_all asp
323: WHERE aid.accounting_event_id = p_acct_event_id
324: AND aid.accounting_event_id = evnt.event_id

Line 1211: FROM xla_events

1207: AND AID.AWT_Invoice_Payment_ID IS NULL
1208: AND NVL(AID.Cancellation_Flag,'N') <> 'Y' -- BUG 6513956
1209: --bug fix 6909150
1210: AND NOT EXISTS (SELECT 1
1211: FROM xla_events
1212: WHERE event_id = AID.accounting_event_id
1213: AND event_type_code IN ('INVOICE CANCELLED',
1214: 'CREDIT MEMO CANCELLED',
1215: 'DEBIT MEMO CANCELLED'));