APPS.AP_ACCTG_PAY_DIST_PKG dependencies on XLA_EVENTS

Line 352: xla_events evnt,

348:
349: CURSOR c_sum_per_event(p_acct_event_id NUMBER) IS
350: SELECT SUM(amount), count(1)
351: FROM ap_invoice_distributions_all aid,
352: xla_events evnt,
353: ap_system_parameters_all asp
354: WHERE aid.accounting_event_id = p_acct_event_id
355: AND aid.accounting_event_id = evnt.event_id
356: AND evnt.event_type_code in ('INVOICE ADJUSTED', 'CREDIT MEMO ADJUSTED',

Line 837: (SELECT 1 FROM xla_events

833: AND aid.prepay_distribution_id IS NULL
834: AND (aid.awt_invoice_payment_id IS NULL OR
835: aid.awt_invoice_payment_id = l_inv_pay_rec.invoice_payment_id) -- bug fix: 6725866
836: AND NOT EXISTS
837: (SELECT 1 FROM xla_events
838: WHERE event_id = aid.accounting_event_id
839: AND application_id = 200
840: AND event_type_code IN('INVOICE CANCELLED', 'PREPAYMENT CANCELLED',
841: 'CREDIT MEMO CANCELLED', 'DEBIT MEMO CANCELLED'));

Line 901: FROM xla_events

897: AND AID.Prepay_Distribution_ID IS NULL
898: AND AID.Prepay_Tax_Parent_ID IS NULL -- For tax dists created in R11.5
899: AND AID.Org_ID = FSP.Org_ID
900: AND NOT EXISTS (SELECT 1
901: FROM xla_events
902: WHERE event_id = AID.accounting_event_id
903: AND application_id = 200 --bug 7308385
904: AND event_type_code IN ('INVOICE CANCELLED', 'PREPAYMENT CANCELLED',
905: 'CREDIT MEMO CANCELLED',

Line 1343: (SELECT 1 FROM xla_events

1339: AND aid.prepay_distribution_id IS NULL
1340: AND (aid.awt_invoice_payment_id IS NULL OR
1341: aid.awt_invoice_payment_id = l_inv_pay_rec.invoice_payment_id) -- bug fix: 6725866
1342: AND NOT EXISTS
1343: (SELECT 1 FROM xla_events
1344: WHERE event_id = aid.accounting_event_id
1345: AND application_id = 200
1346: AND event_type_code IN('INVOICE CANCELLED', 'PREPAYMENT CANCELLED',
1347: 'CREDIT MEMO CANCELLED', 'DEBIT MEMO CANCELLED'));

Line 1960: (SELECT 1 FROM xla_events

1956: AND aid.prepay_distribution_id IS NULL
1957: AND (aid.awt_invoice_payment_id IS NULL OR
1958: aid.awt_invoice_payment_id = l_inv_pay_rec.invoice_payment_id) -- bug fix: 6725866
1959: AND NOT EXISTS
1960: (SELECT 1 FROM xla_events
1961: WHERE event_id = aid.accounting_event_id
1962: AND application_id = 200
1963: AND event_type_code IN('INVOICE CANCELLED', 'PREPAYMENT CANCELLED',
1964: 'CREDIT MEMO CANCELLED', 'DEBIT MEMO CANCELLED'));

Line 5670: XLA_Events XLE,

5666: xte_inv.entity_id aid_Entity_id
5667: FROM AP_Checks_All AC,
5668: AP_System_Parameters_All ASP,
5669: XLA_Transaction_Entities_Upg XTE,
5670: XLA_Events XLE,
5671: AP_Payment_History_All APH,
5672: XLA_AE_Headers AEH,
5673: XLA_AE_Lines AEL,
5674: AP_Inv_Dists_Source AID1,

Line 5788: XLA_Events XLE,

5784: xte_inv.entity_id aid_Entity_id --- changed for bug#7293021
5785: FROM AP_Checks_All AC,
5786: AP_System_Parameters_All ASP,
5787: XLA_Transaction_Entities_Upg XTE,
5788: XLA_Events XLE,
5789: AP_Payment_History_All APH,
5790: XLA_AE_Headers AEH,
5791: XLA_AE_Lines AEL,
5792: AP_Payment_Hist_Dists APHD,

Line 6103: XLA_Events XLE,

6099: xte_inv.entity_id aid_Entity_id
6100: FROM AP_Checks_All AC,
6101: AP_System_Parameters_All ASP,
6102: XLA_Transaction_Entities_Upg XTE,
6103: XLA_Events XLE,
6104: AP_Payment_History_All APH,
6105: XLA_AE_Headers AEH,
6106: XLA_AE_Lines AEL,
6107: AP_Inv_Dists_Source AID1,

Line 6201: XLA_Events XLE,

6197: xte_inv.entity_id AID_Entity_id --- changed for bug#7293021
6198: FROM AP_Checks_All AC,
6199: AP_System_Parameters_All ASP,
6200: XLA_Transaction_Entities_Upg XTE,
6201: XLA_Events XLE,
6202: AP_Payment_History_All APH,
6203: XLA_AE_Headers AEH,
6204: XLA_AE_Lines AEL,
6205: AP_Payment_Hist_Dists APHD,