APPS.APRX_PY dependencies on AP_SYSTEM_PARAMETERS

Line 285: ap_system_parameters sys'; /* bug8760710 */

281: CE_PAYMENT_DOCUMENTS CS1,
282: CE_BANK_ACCT_USES_ALL CBAU,
283: CE_BANK_BRANCHES_V B,
284: CE_BANK_ACCOUNTS ba,
285: ap_system_parameters sys'; /* bug8760710 */
286: /*AP_BANK_BRANCHES B,
287: AP_BANK_ACCOUNTS ba'; Bug 6967238
288: */
289: --

Line 322: FROM ap_system_parameters sys, gl_sets_of_books sob

318: -- Commenting for bug8760710
319: /*
320: SELECT sob.name, sob.currency_code
321: INTO aprx_py.var.ORGANIZATION_NAME, aprx_py.var.FUNCTIONAL_CURRENCY_CODE
322: FROM ap_system_parameters sys, gl_sets_of_books sob
323: WHERE sys.set_of_books_id = sob.set_of_books_id;
324: */
325: --Commenting for bug8760710
326:

Line 343: FROM ap_system_parameters sys, gl_sets_of_books sob

339: /* bug13941628 Use this sql only if report runs by OU context */
340: if (nvl(param.org_id,-9999) <> -9999) then
341: SELECT sob.name, sob.currency_code
342: INTO aprx_py.var.ORGANIZATION_NAME, aprx_py.var.FUNCTIONAL_CURRENCY_CODE
343: FROM ap_system_parameters sys, gl_sets_of_books sob
344: WHERE sys.set_of_books_id = sob.set_of_books_id
345: and sys.org_id = param.org_id;
346: END IF;
347: /* bug13941628 */