Operation Details
Description: Retrieves the cells where the value specified is between the minimum and maximum values specified for the cell.
Sterotype: nsmulti
SQL 
SELECT
  rateCellID,
  rateColumnID,
  rateCellMin,
  rateCellMax,
  rateCellValue,
  rateCellType,
  rateCellIndex,
  anyMinimumInd,
  anyMaximumInd,
  rateRowID,
  blankCellInd
INTO
  :rateCellID,
  :rateColumnID,
  :rateCellMin,
  :rateCellMax,
  :rateCellValue,
  :rateCellType,
  :rateCellIndex,
  :anyMinimumInd,
  :anyMaximumInd,
  :rateRowID,
  :blankCellInd 
FROM
  RateCell 
WHERE rateColumnID = :rateColumnID 
  AND 
  (
    rateCellMin <= :rateCellValue 
    OR anyMinimumInd = :trueValue 
  ) 
  AND 
  (
    rateCellMax >= :rateCellValue 
    OR anyMaximumInd = :trueValue 
  ) 
  AND 
  (
    :rateCellType IS NULL 
    OR rateCellType = :rateCellType 
  )