Operation Details
Description: Retrieves the columns where the value specified is between the minimum and maximum values specified for the column.
Sterotype: nsmulti
SQL 
SELECT
  rateColumnID,
  rateHeaderID,
  parentColumnID,
  rateColumnKeyMin,
  rateColumnKeyMax,
  rateColumnKeyValue,
  rateColumnType,
  rateColumnIndex,
  anyMinimumInd,
  anyMaximumInd
INTO
  :rateColumnID,
  :rateHeaderID,
  :parentColumnID,
  :rateColumnKeyMin,
  :rateColumnKeyMax,
  :rateColumnKeyValue,
  :rateColumnType,
  :rateColumnIndex,
  :anyMinimumInd,
  :anyMaximumInd 
FROM
  RateColumn 
WHERE rateHeaderID = :rateHeaderID 
  AND 
  (
    rateColumnKeyMin <= :value 
    OR anyMinimumInd = :trueValue 
  ) 
  AND 
  (
    rateColumnKeyMax >= :value 
    OR anyMaximumInd = :trueValue 
  ) 
  AND 
  (
    :rateColumnType IS NULL 
    OR rateColumnType = :rateColumnType 
  )