DBA Data[Home] [Help]

APPS.WSH_UTIL_CORE dependencies on GL_LEDGERS_PUBLIC_V

Line 3310: l_functional_currency GL_LEDGERS_PUBLIC_V.currency_code%type;

3306: x_func_currency OUT NOCOPY VARCHAR2 ,
3307: x_return_status OUT NOCOPY VARCHAR2)
3308: IS
3309: l_ledger_id NUMBER;
3310: l_functional_currency GL_LEDGERS_PUBLIC_V.currency_code%type;
3311: l_org_id NUMBER;
3312: --
3313:
3314: -- this cursor is copied from OEXVSPMB.pls, function Get_AR_Sys_Params

Line 3319: FROM ar_system_parameters_all ar, gl_ledgers_public_v glpv

3315: -- to get ledger id from org_id
3316: -- LE Uptake
3317: CURSOR c_ledger_and_func_curr (v_org_id NUMBER) IS
3318: SELECT ar.org_id, ar.set_of_books_id, glpv.currency_code
3319: FROM ar_system_parameters_all ar, gl_ledgers_public_v glpv
3320: WHERE ar.ORG_ID = p_org_id
3321: AND glpv.ledger_id = ar.set_of_books_id;
3322:
3323: --