Operation Details
Description: To retrieve the next CoverPeriodTo date using the caseID of the case being processed and the change effective date from the re-assessment.
Sterotype: ns
SQL 
SELECT
  MAX(coverPeriodTo)
INTO
  :coverPeriodTo 
FROM
  InstructionLineItem 
WHERE InstructionLineItem.caseID = :caseID 
  AND InstructionLineItem.coverPeriodFrom <= :changeEffectiveDate 
  AND InstructionLineItem.coverPeriodTo >= :changeEffectiveDate