Operation Details
Description: This operation will list all the currency exchange rates that are active for the current date. It will only show one rate per currency.
Sterotype: nsmulti
SQL 
SELECT
  currencyExchangeID,
  currencyTypeCode,
  rate,
  rateFromDate,
  rateToDate,
  statusCode,
  versionNo
INTO
  :currencyExchangeID,
  :currencyTypeCode,
  :rate,
  :rateFromDate,
  :rateToDate,
  :statusCode,
  :versionNo 
FROM
  CurrencyExchange 
WHERE 
  (
    :inputDate >= rateFromDate 
    OR rateFromDate IS NULL 
  ) 
  AND 
  (
    :inputDate <= rateToDate 
    OR rateToDate IS NULL 
  ) 
  AND 
  (
    :statusCode = statusCode 
  )