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 |