DBA Data[Home] [Help]

APPS.AP_PAYMENT_UTIL_PKG dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 268: ap_system_parameters_all asp

264:
265: SELECT count(*)
266: INTO l_ps_ur_count
267: FROM ap_selected_invoices_All asi,
268: ap_system_parameters_all asp
269: WHERE asi.org_id = asp.org_id
270: AND asi.checkrun_id = p_checkrun_id
271: AND asp.base_currency_code = p_ledger_currency_code
272: AND asi.payment_currency_code = p_payment_currency_code

Line 297: ap_system_parameters_all asp

293:
294: SELECT count(*)
295: INTO l_missing_rates_ps_count
296: FROM ap_selected_invoices_all asi,
297: ap_system_parameters_all asp
298: WHERE asi.org_id = asp.org_id
299: AND asi.checkrun_id = p_checkrun_id
300: AND asp.base_currency_code <> asi.payment_currency_code
301: AND asi.payment_exchange_rate_type = 'User'