APPS.OE_UPGRADE_MISC_NEW dependencies on AR_SYSTEM_PARAMETERS_ALL

Line 367: l_AR_Sys_Param_Rec AR_SYSTEM_PARAMETERS_ALL%ROWTYPE;

363: FUNCTION GET_SOB_CURRENCY(p_org_id IN NUMBER)
364: RETURN VARCHAR2
365: IS
366: l_curr_code VARCHAR2(15);
367: l_AR_Sys_Param_Rec AR_SYSTEM_PARAMETERS_ALL%ROWTYPE;
368: l_sob_id NUMBER;
369:
370: --
371: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 378: FROM ar_system_parameters_all a,

374:
375: IF oe_code_control.code_release_level < '110510' THEN
376: SELECT b.currency_code
377: INTO l_curr_code
378: FROM ar_system_parameters_all a,
379: GL_SETS_OF_BOOKS b
380: WHERE NVL(a.org_id,-99) = NVL(p_org_id,-99)
381: AND a.set_of_books_id = b.set_of_books_id
382: AND ROWNUM =1;