APPS.AP_ACCTG_PREPAY_DIST_PKG dependencies on XLA_EVENTS

Line 428: l_accounting_event_id XLA_EVENTS.event_id%TYPE := -99;

424: (P_Invoice_ID IN NUMBER
425: ,P_Calling_Sequence IN VARCHAR2
426: ) IS
427: l_prepay_hist_id AP_PREPAY_HISTORY_ALL.Prepay_History_id%TYPE := -99;
428: l_accounting_event_id XLA_EVENTS.event_id%TYPE := -99;
429: l_historical_flag AP_PREPAY_HISTORY_ALL.Historical_flag%TYPE := 'N';
430: l_posted_flag AP_PREPAY_HISTORY_ALL.Posted_flag%TYPE := 'N';
431: l_upg_batch_id XLA_AE_HEADERS.Upg_Batch_Id%TYPE := -99;
432:

Line 470: xla_events evnt,

466:
467: CURSOR c_sum_per_event(p_acct_event_id NUMBER) IS
468: SELECT SUM(amount), count(1)
469: FROM ap_invoice_distributions_all aid,
470: xla_events evnt,
471: xla_ae_headers xah,
472: ap_system_parameters_all asp
473: WHERE aid.accounting_event_id = p_acct_event_id
474: AND aid.accounting_event_id = evnt.event_id

Line 856: FROM xla_events

852: AND AID.Prepay_Tax_Parent_ID IS NULL -- For tax dists created in R11.5
853: AND AID.AWT_Invoice_Payment_ID IS NULL
854: AND NVL(AID.Cancellation_Flag,'N') <> 'Y' -- BUG 6513956
855: AND NOT EXISTS (SELECT 1 --bug fix 6909150
856: FROM xla_events
857: WHERE event_id = AID.accounting_event_id
858: AND application_id = 200
859: AND event_type_code IN ('INVOICE CANCELLED',
860: 'CREDIT MEMO CANCELLED',

Line 1241: FROM xla_events

1237: AND AID.Prepay_Tax_Parent_ID IS NULL -- For tax dists created in R11.5
1238: AND AID.AWT_Invoice_Payment_ID IS NULL
1239: AND NVL(AID.Cancellation_Flag,'N') <> 'Y' -- BUG 6513956
1240: AND NOT EXISTS (SELECT 1 --bug fix 6909150
1241: FROM xla_events
1242: WHERE event_id = AID.accounting_event_id
1243: AND application_id = 200
1244: AND event_type_code IN ('INVOICE CANCELLED',
1245: 'CREDIT MEMO CANCELLED',

Line 1367: FROM xla_events

1363: AND AID.Prepay_Tax_Parent_ID IS NULL -- For tax dists created in R11.5
1364: AND AID.AWT_Invoice_Payment_ID IS NULL
1365: AND NVL(AID.Cancellation_Flag,'N') <> 'Y' -- BUG 6513956
1366: AND NOT EXISTS (SELECT 1 --bug fix 6909150
1367: FROM xla_events
1368: WHERE event_id = AID.accounting_event_id
1369: AND application_id = 200
1370: AND event_type_code IN ('INVOICE CANCELLED',
1371: 'CREDIT MEMO CANCELLED',

Line 1814: FROM xla_events

1810: AND AID.AWT_Invoice_Payment_ID IS NULL
1811: AND NVL(AID.Cancellation_Flag,'N') <> 'Y' -- BUG 6513956
1812: --bug fix 6909150
1813: AND NOT EXISTS (SELECT 1
1814: FROM xla_events
1815: WHERE event_id = AID.accounting_event_id
1816: AND event_type_code IN ('INVOICE CANCELLED',
1817: 'CREDIT MEMO CANCELLED',
1818: 'DEBIT MEMO CANCELLED'));

Line 2746: xla_events xer

2742: FND_GLOBAL.Conc_Request_ID
2743: FROM AP_Prepay_App_Dists APAD,
2744: ap_prepay_history_all aph, --Bug 9112240
2745: ap_prepay_history_all aphr,
2746: xla_events xer
2747: WHERE apad.Prepay_App_Distribution_ID = P_Prepay_Reversal_ID
2748: AND apad.prepay_history_id = aph.prepay_history_id --Bug 9112240
2749: AND aphr.prepay_history_id = p_prepay_hist_rec.prepay_history_id
2750: AND aphr.accounting_event_id = xer.event_id(+)

Line 3419: XLA_Events XLE,

3415: APAD.Prepay_Dist_Lookup_Code
3416: FROM AP_Invoices_All AI,
3417: AP_System_Parameters_All ASP,
3418: XLA_Transaction_Entities_upg XTE,
3419: XLA_Events XLE,
3420: AP_Prepay_App_Dists APAD,
3421: AP_Invoice_Distributions_All AID,
3422: XLA_AE_Headers AEH,
3423: XLA_AE_Lines AEL

Line 3521: XLA_Events XLE,

3517: APAD.Prepay_Dist_Lookup_Code
3518: FROM AP_Invoices_All AI,
3519: AP_System_Parameters_All ASP,
3520: XLA_Transaction_Entities_upg XTE,
3521: XLA_Events XLE,
3522: AP_Prepay_App_Dists APAD,
3523: AP_Invoice_Distributions_All AID,
3524: XLA_AE_Headers AEH,
3525: XLA_AE_Lines AEL