Database SQL Operation: RateCell.readValueByColumnAndRowIndex
Description: | Reads a Rate Cell's value by column, row, rateTable index, effectiveDate and rateStatus. |
Sterotype: | ns |
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.rateRowIndex = :rateRowIndex
AND RateCell.rateRowID = RateRow.rateRowID
AND RateRow.rateHeaderID = RateHeader.rateHeaderID
AND RateHeader.rateStatus = :rateStatus
)
|