294: BEGIN
295:
296: SELECT sob.currency_code
297: INTO x_functional_currency_code
298: FROM gl_sets_of_books sob, financials_system_params_all fsp
299: WHERE nvl(fsp.org_id, -99) = nvl(p_org_id, -99)
300: AND fsp.set_of_books_id = sob.set_of_books_id;
301:
302: EXCEPTION
516: FUNCTION get_cross_ou_rate ( p_from_ou_id IN NUMBER, p_to_ou_id IN NUMBER )
517: RETURN NUMBER IS
518: l_api_name CONSTANT varchar2(30) := 'GET_CROSS_OU_RATE';
519:
520: l_from_ou_currency GL_SETS_OF_BOOKS.currency_code%TYPE;
521: l_to_ou_currency GL_SETS_OF_BOOKS.currency_code%TYPE;
522: l_rate_type PO_SYSTEM_PARAMETERS_ALL.default_rate_type%TYPE;
523: l_rate NUMBER;
524: l_display_rate NUMBER;
517: RETURN NUMBER IS
518: l_api_name CONSTANT varchar2(30) := 'GET_CROSS_OU_RATE';
519:
520: l_from_ou_currency GL_SETS_OF_BOOKS.currency_code%TYPE;
521: l_to_ou_currency GL_SETS_OF_BOOKS.currency_code%TYPE;
522: l_rate_type PO_SYSTEM_PARAMETERS_ALL.default_rate_type%TYPE;
523: l_rate NUMBER;
524: l_display_rate NUMBER;
525: l_return_status VARCHAR2(1);