294: SELECT
295: CURRENCY_CODE
296: INTO BASE_CURRENCY
297: FROM
298: GL_SETS_OF_BOOKS
299: WHERE SET_OF_BOOKS_ID = P_SOB_ID;
300: RETURN (BASE_CURRENCY);
301: EXCEPTION
302: WHEN OTHERS THEN
1168: sob.currency_code
1169: INTO
1170: l_company_name ,
1171: l_functional_currency
1172: FROM gl_sets_of_books sob,
1173: fnd_currencies cur
1174: WHERE sob.set_of_books_id = p_sob_id
1175: AND sob.currency_code = cur.currency_code
1176: ;