| Operation Details |  |
| Description: | To retrieve the latest CoverPeriodTo date for a canceled payment being reassessed using the CaseID & FinInstructionID |
| Sterotype: | ns |
| SQL | |
SELECT MAX(coverPeriodTo) INTO :coverPeriodTo FROM InstructionLineItem WHERE InstructionLineItem.caseID = :caseID AND InstructionLineItem.finInstructionID = :finInstructionID |