DBA Data[Home] [Help]

APPS.AP_PAYMENT_UTIL_PKG dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 286: ap_system_parameters_all asp

282:
283: SELECT count(*)
284: INTO l_ps_ur_count
285: FROM ap_selected_invoices_All asi,
286: ap_system_parameters_all asp
287: WHERE asi.org_id = asp.org_id
288: AND asi.checkrun_id = p_checkrun_id
289: AND asp.base_currency_code = p_ledger_currency_code
290: AND asi.payment_currency_code = p_payment_currency_code

Line 315: ap_system_parameters_all asp

311:
312: SELECT count(*)
313: INTO l_missing_rates_ps_count
314: FROM ap_selected_invoices_all asi,
315: ap_system_parameters_all asp
316: WHERE asi.org_id = asp.org_id
317: AND asi.checkrun_id = p_checkrun_id
318: AND asp.base_currency_code <> asi.payment_currency_code
319: AND asi.payment_exchange_rate_type = 'User'