DBA Data[Home] [Help]

APPS.AP_ACCTG_PREPAY_DIST_PKG dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 322: ap_system_parameters_all asp

318: SELECT SUM(amount), count(1)
319: FROM ap_invoice_distributions_all aid,
320: xla_events evnt,
321: xla_ae_headers xah,
322: ap_system_parameters_all asp
323: WHERE aid.accounting_event_id = p_acct_event_id
324: AND aid.accounting_event_id = evnt.event_id
325: AND evnt.event_type_code in ('INVOICE ADJUSTED', 'CREDIT MEMO ADJUSTED',
326: 'DEBIT MEMO ADJUSTED')

Line 585: FROM ap_system_parameters_all asp,

581:
582: -- bug 7611160
583: SELECT asp.base_currency_code
584: INTO ap_accounting_pay_pkg.g_base_currency_code
585: FROM ap_system_parameters_all asp,
586: ap_invoices_all ai
587: WHERE asp.org_id = ai.org_id
588: AND ai.invoice_id = l_inv_rec.invoice_id;
589: