DBA Data[Home] [Help]

APPS.WSH_UTIL_CORE dependencies on GL_LEDGERS_PUBLIC_V

Line 3274: l_functional_currency GL_LEDGERS_PUBLIC_V.currency_code%type;

3270: x_func_currency OUT NOCOPY VARCHAR2 ,
3271: x_return_status OUT NOCOPY VARCHAR2)
3272: IS
3273: l_ledger_id NUMBER;
3274: l_functional_currency GL_LEDGERS_PUBLIC_V.currency_code%type;
3275: l_org_id NUMBER;
3276: --
3277:
3278: -- this cursor is copied from OEXVSPMB.pls, function Get_AR_Sys_Params

Line 3283: FROM ar_system_parameters_all ar, gl_ledgers_public_v glpv

3279: -- to get ledger id from org_id
3280: -- LE Uptake
3281: CURSOR c_ledger_and_func_curr (v_org_id NUMBER) IS
3282: SELECT ar.org_id, ar.set_of_books_id, glpv.currency_code
3283: FROM ar_system_parameters_all ar, gl_ledgers_public_v glpv
3284: WHERE ar.ORG_ID = p_org_id
3285: AND glpv.ledger_id = ar.set_of_books_id;
3286:
3287: --