Operation Details
Description: To retrieve the coverPeriodTo date of a period using the CaseID and changeDate
Sterotype: ns
SQL 
SELECT
  MAX(coverPeriodFrom)
INTO
  :coverPeriodFrom 
FROM
  InstructionLineItem 
WHERE InstructionLineItem.caseID = :caseID 
  AND InstructionLineItem.coverPeriodFrom <= :changeEffectiveDate 
  AND InstructionLineItem.coverPeriodTo >= :changeEffectiveDate