| Operation Details |  |
| Description: | To retrieve all caseIDs from the InstructionLineItem entity based on the FinancialInstructionID. |
| Sterotype: | nsmulti |
| SQL | |
SELECT caseID INTO :caseID FROM InstructionLineItem WHERE InstructionLineItem.finInstructionID = :finInstructionID AND NOT(InstructionLineItem.caseID IS NULL) ORDER BY caseID |