| Operation Details |  |
| Description: | Reads the earliest cover period from date based on a case identifier and a ILI status code. |
| Sterotype: | ns |
| SQL | |
SELECT MIN(coverPeriodFrom) INTO :coverPeriodFrom FROM InstructionLineItem WHERE InstructionLineItem.caseID = :caseID AND InstructionLineItem.statusCode = :status |