DBA Data[Home] [Help]

APPS.OE_UPGRADE_MISC dependencies on AR_SYSTEM_PARAMETERS_ALL

Line 377: l_AR_Sys_Param_Rec AR_SYSTEM_PARAMETERS_ALL%ROWTYPE;

373: FUNCTION GET_SOB_CURRENCY(p_org_id IN NUMBER)
374: RETURN VARCHAR2
375: IS
376: l_curr_code VARCHAR2(15);
377: l_AR_Sys_Param_Rec AR_SYSTEM_PARAMETERS_ALL%ROWTYPE;
378: l_sob_id NUMBER;
379:
380: BEGIN
381:

Line 385: FROM ar_system_parameters_all a,

381:
382: IF oe_code_control.code_release_level < '110510' THEN
383: SELECT b.currency_code
384: INTO l_curr_code
385: FROM ar_system_parameters_all a,
386: GL_SETS_OF_BOOKS b
387: WHERE NVL(a.org_id,-99) = NVL(p_org_id,-99)
388: AND a.set_of_books_id = b.set_of_books_id
389: AND ROWNUM =1;