Operation Details |
Description: | Reads the latest cover period to date on a case for where the status is 'Processed' and the type is not 'Reversed'. |
Sterotype: | ns |
SQL |
SELECT MAX(coverPeriodTo) INTO :coverPeriodTo FROM InstructionLineItem WHERE caseID = :caseID AND instructionLineItemType <> :instructionLineItemType AND statusCode = :statusCode |