APPS.AP_ACCOUNTING_PAY_PKG dependencies on XLA_EVENTS_GT

Line 45: FROM XLA_Events_GT

41: Event_Number,
42: Event_Status_Code,
43: Entity_Code,
44: Source_ID_Int_1
45: FROM XLA_Events_GT
46: WHERE (Entity_Code = 'AP_PAYMENTS'
47: OR Event_Type_Code IN ('PREPAYMENT APPLIED',
48: 'PREPAYMENT UNAPPLIED',
49: 'PREPAYMENT APPLICATION ADJ'))

Line 320: FROM xla_events_gt xeg

316: SELECT DISTINCT xeg.entity_id
317: , xeg.ledger_id
318: INTO l_entity_id
319: , l_ledger_id
320: FROM xla_events_gt xeg
321: WHERE xeg.event_id = l_xla_event_rec.event_id
322: AND xeg.application_id = 200;
323:
324: XLA_ACCOUNTING_ERR_PKG.build_message('SQLAP',

Line 400: FROM XLA_Events_GT

396: -- Bug 5098657. Added the where condition for both the delete statements
397: DELETE FROM AP_Payment_Hist_Dists
398: WHERE Accounting_Event_ID IN
399: (SELECT Event_ID
400: FROM XLA_Events_GT
401: WHERE Entity_Code = 'AP_PAYMENTS');
402:
403: DELETE FROM AP_Prepay_App_Dists
404: WHERE Accounting_Event_ID IN

Line 406: FROM XLA_Events_GT

402:
403: DELETE FROM AP_Prepay_App_Dists
404: WHERE Accounting_Event_ID IN
405: (SELECT Event_ID
406: FROM XLA_Events_GT
407: WHERE Event_Type_Code IN ('PREPAYMENT APPLICATION ADJ'));
408:
409:
410: EXCEPTION

Line 1588: xla_events_gt xe,

1584: CURSOR Aprvd_UnPrtd_His_Inv IS
1585: SELECT ai.invoice_id
1586: FROM ap_invoice_distributions_all aid,
1587: ap_invoices_all ai,
1588: xla_events_gt xe,
1589: xla_events xle,
1590: financials_system_params_all fsp
1591: WHERE xe.event_type_code IN('PREPAYMENT APPLIED', 'PREPAYMENT UNAPPLIED')
1592: AND xe.event_status_code NOT IN('N', 'P')

Line 1896: , xla_events_gt xgt

1892: , ap_invoice_payments_all aip
1893: , xla_event_types_b xet
1894: , xla_event_types_b xet_rel
1895: , xla_events xe
1896: , xla_events_gt xgt
1897: WHERE aip.invoice_id = p_inv_rec.invoice_id
1898: AND aph.check_id = aip.check_id
1899: AND xe.event_id = aph.accounting_event_id
1900: AND xet.event_type_code = p_xla_event_rec.event_type_code

Line 1919: xla_events_gt xgt

1915: UNION
1916: -- prepay adjustment
1917: SELECT MAX(apph.accounting_event_id) accounting_event_id
1918: FROM ap_prepay_history_all apph,
1919: xla_events_gt xgt
1920: WHERE xgt.event_id = apph.accounting_event_id
1921: AND apph.posted_flag = 'S'
1922: AND apph.invoice_id = p_inv_rec.invoice_id
1923: AND apph.invoice_adjustment_event_id IS NOT NULL