Operation Details
Description: To retrieve the earliest CoverPeriodFrom date for a canceled payment being reassessed using the CaseID & FinInstructionID
Sterotype: ns
SQL
SELECT
  MIN(coverPeriodFrom)
INTO
  :coverPeriodFrom 
FROM
  InstructionLineItem 
WHERE InstructionLineItem.caseID = :caseID 
  AND InstructionLineItem.finInstructionID = :finInstructionID