11i里求最新的美元汇率

zhaqiong

function  FAST_GET_USD_CNY_RATE_BY_TSnT  return float is
ret float ;
begin
     
     select 1/avg(exchange_rate) into ret from RA_CUSTOMER_TRX_ALL
     where last_update_date =
     (
           select max(last_update_date) from RA_CUSTOMER_TRX_ALL where (cust_trx_type_id =1025 or cust_trx_type_id =1026)
     )
     and (cust_trx_type_id =1025 or cust_trx_type_id =1026) ;
     
     return ret ;
end  ;