232: SELECT
233: PRECISION
234: INTO L_PRECISION
235: FROM
236: FND_CURRENCIES
237: WHERE CURRENCY_CODE = L_CURRENCY;
238: EXCEPTION
239: WHEN NO_DATA_FOUND THEN
240: L_PRECISION := 2;
322: SELECT
323: PRECISION
324: INTO L_PRECISION
325: FROM
326: FND_CURRENCIES
327: WHERE CURRENCY_CODE = L_CURRENCY;
328: EXCEPTION
329: WHEN NO_DATA_FOUND THEN
330: L_PRECISION := 2;
515: SELECT
516: PRECISION
517: INTO W_PRECISION
518: FROM
519: FND_CURRENCIES
520: WHERE CURRENCY_CODE = CURRENCY1;
521: RETURN (W_PRECISION);
522: EXCEPTION
523: WHEN NO_DATA_FOUND THEN
871: INTO
872: l_company_name ,
873: l_functional_currency
874: FROM gl_sets_of_books sob,
875: fnd_currencies cur
876: WHERE sob.set_of_books_id = p_sob_id
877: AND sob.currency_code = cur.currency_code
878: ;
879: