Operation Details
Description: Gathers group (row) information from the cell data. Grouping is done by cell type. Selection is ordered by minimum cell index.
Sterotype: nsmulti
SQL 
SELECT
  MIN(RateCell.rateCellIndex) rateSubRowMinIndex,
  RateCell.rateCellType,
  MAX(RateCell.rateCellIndex) - MIN(RateCell.rateCellIndex) +1 rateSubRowCount
INTO
  :rateSubRowMinIndex,
  :rateRowType,
  :rateSubRowCount 
FROM
  RateCell,
  RateColumn,
  RateHeader 
WHERE RateHeader.rateHeaderID = :rateHeaderID 
  AND RateHeader.rateHeaderID = RateColumn.rateHeaderID 
  AND RateColumn.rateColumnID = RateCell.rateColumnID 
GROUP
  BY RateCell.rateCellType 
ORDER BY rateSubRowMinIndex