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