APPS.AP_SLA_PROCESSING_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 495: AP_SYSTEM_PARAMETERS_ALL APSP

491: XPAE.ledger_id ledger_id
492: FROM XLA_POST_ACCTG_EVENTS_V XPAE,
493: XLA_TRANSACTION_ENTITIES XTE,
494: GL_SETS_OF_BOOKS GSOB,
495: AP_SYSTEM_PARAMETERS_ALL APSP
496: WHERE XPAE.ledger_id = GSOB.set_of_books_id
497: AND XPAE.entity_id = XTE.entity_id
498: AND XTE.application_id = 200
499: AND XTE.security_id_int_1 = APSP.org_id;

Line 1849: FROM ap_system_parameters asp

1845: FORALL i IN 1 .. l_event_ids.count
1846: UPDATE ap_payment_history_all APH
1847: SET APH.POSTED_FLAG = CASE WHEN l_event_status(i) = 'U'
1848: AND EXISTS(SELECT 1
1849: FROM ap_system_parameters asp
1850: WHERE asp.when_to_account_pmt = 'CLEARING ONLY'
1851: -- AND asp.org_id = l_org_ids(i)
1852: AND asp.org_id = aph.org_id
1853: AND aph.accounting_event_id = l_event_ids(i)

Line 1893: FROM ap_system_parameters asp, ap_payment_history_all aph

1889: FORALL i IN 1 .. l_event_ids.count
1890: UPDATE ap_invoice_payments_all AIP
1891: SET AIP.POSTED_FLAG = CASE WHEN l_event_status(i) = 'U'
1892: AND EXISTS(SELECT 1
1893: FROM ap_system_parameters asp, ap_payment_history_all aph
1894: WHERE asp.when_to_account_pmt = 'CLEARING ONLY'
1895: --AND asp.org_id = l_org_id(i)
1896: AND asp.org_id = aph.org_id
1897: AND aph.accounting_event_id = l_event_ids(i)