APPS.APRX_PY dependencies on GL_SETS_OF_BOOKS

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 332: FROM gl_sets_of_books sob

328: /* bug13941628 Use this sql only if report runs by ledger context */
329: if (nvl(param.ledger_id,-9999) <> -9999) then
330: SELECT sob.name, sob.currency_code
331: INTO aprx_py.var.ORGANIZATION_NAME, aprx_py.var.FUNCTIONAL_CURRENCY_CODE
332: FROM gl_sets_of_books sob
333: WHERE sob.set_of_books_id=param.ledger_id ;
334: END IF;
335: /* bug13941628 */
336: /* End of bug8760710 */

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 */