Operation Details |
Description: | Searches for all columns with a higher index within the Rate Table and returns their rate column ID, index and type. |
Sterotype: | nsmulti |
SQL |
SELECT rateColumnID, rateColumnIndex, rateColumnType INTO :rateColumnID, :rateColumnIndex, :rateColumnType FROM RateColumn WHERE rateHeaderID = :rateHeaderID AND ( rateColumnIndex >= :index ) AND ( parentColumnID IS NULL ) ORDER BY rateColumnType, rateColumnIndex ASC |