APPS.AP_ACCTG_PAY_ROUND_PKG dependencies on XLA_EVENTS

Line 42: l_acctg_event_id XLA_EVENTS.EVENT_ID%TYPE;

38: l_procedure_name CONSTANT VARCHAR2(30) := 'DO_Rounding';
39: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
40:
41: -- bug 6600341
42: l_acctg_event_id XLA_EVENTS.EVENT_ID%TYPE;
43: exec_final_payment VARCHAR2(1); --bug 7614480
44: l_max_prepay_app_dist_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE; --bug 7614480
45:
46: BEGIN

Line 345: FROM xla_events

341: AND AID.Prepay_Tax_Parent_ID IS NULL -- For tax dists created in R11.5
342: AND AID.Org_ID = FSP.Org_ID
343: --Bug6511672
344: /*AND 'INVOICE CANCELLED' <> (SELECT event_type_code
345: FROM xla_events
346: WHERE event_id = AID.accounting_event_id)*/
347: --bug6614371
348: -- Bug 6712649. Added Credit and Debit memo cancelled
349: AND NOT EXISTS (SELECT 1

Line 350: FROM xla_events

346: WHERE event_id = AID.accounting_event_id)*/
347: --bug6614371
348: -- Bug 6712649. Added Credit and Debit memo cancelled
349: AND NOT EXISTS (SELECT 1
350: FROM xla_events
351: WHERE event_id = AID.accounting_event_id
352: AND event_type_code IN ('INVOICE CANCELLED', 'PREPAYMENT CANCELLED',
353: 'CREDIT MEMO CANCELLED',
354: 'DEBIT MEMO CANCELLED'));

Line 368: xla_events evnt,

364: -- under no liability posting method.
365: CURSOR c_sum_per_event(p_acct_event_id NUMBER) IS
366: SELECT SUM(amount), count(1)
367: FROM ap_invoice_distributions_all aid,
368: xla_events evnt,
369: ap_system_parameters_all asp
370: WHERE aid.accounting_event_id = p_acct_event_id
371: AND aid.accounting_event_id = evnt.event_id
372: AND evnt.event_type_code IN ('INVOICE ADJUSTED',