Operation Details
Description: Reads a Rate Cell's value by column, row, rateTable type, effectiveDate and rateStatus.
Sterotype: ns
SQL 
SELECT
  RateCell.rateCellValue,
  RateCell.rateCellID
INTO
  :rateCellValue,
  :rateCellID 
FROM
  RateCell,
  RateColumn,
  RateRow,
  RateHeader 
WHERE effectiveDate = 
  ( 
  SELECT
    MAX(effectiveDate) 
  FROM
    RateHeader 
  WHERE effectiveDate <= :effectiveDate 
    AND rateTableType = :rateTableType 
    AND rateStatus = :rateStatus 
  ) 
  AND RateHeader.rateTableType = :rateTableType 
  AND 
  (
    RateColumn.rateColumnType = :rateColumnType 
    AND RateCell.rateColumnID = RateColumn.rateColumnID 
    AND RateColumn.rateHeaderID = RateHeader.rateHeaderID 
  ) 
  AND 
  (
    RateRow.rateRowType = :rateRowType 
    AND RateCell.rateRowID = RateRow.rateRowID 
    AND RateRow.rateHeaderID = RateHeader.rateHeaderID 
    AND RateHeader.rateStatus = :rateStatus 
  )