[Home] [Help]
164: SELECT
165: DECIMAL_PRECISION
166: INTO V_PRECISION
167: FROM
168: GL_CURR_MST
169: WHERE CURRENCY_CODE = P_CUR;
170: EXCEPTION
171: WHEN OTHERS THEN
172: V_PRECISION := 0;
241: BEGIN
242: v_value2:=v_value1;
243: begin
244: select decimal_precision into xx
245: from gl_curr_mst
246: where currency_code = billing_currency ;
247: Exception
248: when others then
249: xx := 0 ;