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