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