APPS.AP_SLA_PROCESSING_PKG dependencies on XLA_EVENTS_GT

Line 535: FROM xla_events_gt XEG

531:
532: --bug9377273
533: CURSOR l_events_gt_cur IS
534: SELECT XEG.event_id
535: FROM xla_events_gt XEG
536: WHERE XEG.application_id = 200
537: AND XEG.entity_code = 'AP_PAYMENTS';
538:
539: --bug 10412623, removed code introduced in 9936620

Line 1758: ( select event_id from xla_events_gt);

1754: /* -- need to make the following autonmous commit
1755: UPDATE ap_payment_history_All APH
1756: SET POSTED_FLAG = 'N'
1757: WHERE APH.accounting_event_id in
1758: ( select event_id from xla_events_gt);
1759:
1760: UPDATE ap_invoice_distributions_All AID
1761: SET POSTED_FLAG = 'N'
1762: WHERE AID.accounting_event_id in

Line 1763: ( select event_id from xla_events_gt);

1759:
1760: UPDATE ap_invoice_distributions_All AID
1761: SET POSTED_FLAG = 'N'
1762: WHERE AID.accounting_event_id in
1763: ( select event_id from xla_events_gt);
1764:
1765: UPDATE ap_self_assessed_tax_dist_all AID
1766: SET POSTED_FLAG = 'N'
1767: WHERE AID.accounting_event_id in

Line 1768: ( select event_id from xla_events_gt);

1764:
1765: UPDATE ap_self_assessed_tax_dist_all AID
1766: SET POSTED_FLAG = 'N'
1767: WHERE AID.accounting_event_id in
1768: ( select event_id from xla_events_gt);
1769:
1770: UPDATE ap_invoice_payments_all AIP
1771: SET POSTED_FLAG = 'N'
1772: WHERE AIP.accounting_event_id in

Line 1773: ( select event_id from xla_events_gt);

1769:
1770: UPDATE ap_invoice_payments_all AIP
1771: SET POSTED_FLAG = 'N'
1772: WHERE AIP.accounting_event_id in
1773: ( select event_id from xla_events_gt);
1774:
1775: UPDATE ap_prepay_history_all APPH
1776: SET APPH.posted_flag = 'N'
1777: WHERE APPH.accounting_event_id in

Line 1778: ( select event_id from xla_events_gt);

1774:
1775: UPDATE ap_prepay_history_all APPH
1776: SET APPH.posted_flag = 'N'
1777: WHERE APPH.accounting_event_id in
1778: ( select event_id from xla_events_gt);
1779: -- */
1780:
1781:
1782: IF (SQLCODE <> -20001) THEN

Line 1845: FROM xla_events_gt XEG

1841: IS
1842:
1843: CURSOR l_events_cur IS
1844: SELECT XEG.event_id
1845: FROM xla_events_gt XEG
1846: WHERE XEG.application_id = 200;
1847:
1848: l_event_ids l_event_ids_typ;
1849: l_debug_info VARCHAR2(240);

Line 1899: -- in xla_events_gt

1895:
1896: -------------------------------------------------------------------------
1897: -- The call below will populate the prepayment distributions table
1898: -- and the payment distributions table for the events that are
1899: -- in xla_events_gt
1900: -------------------------------------------------------------------------
1901:
1902: AP_ACCOUNTING_PAY_PKG.Do_Pay_Accounting(l_curr_calling_sequence);
1903: