Operation Details
Description: To get a list of CaseIDs for a specified financial instruction ID.
Sterotype: nsmulti
SQL 
SELECT
  DISTINCT(InstructionLineItem.caseID)
INTO
  :caseID 
FROM
  InstructionLineItem,
  InstructionLineItemRelation 
WHERE InstructionLineItemRelation.relatedLineItemID in 
  ( 
  SELECT
    InstructionLineItem.instructLineItemID 
  FROM
    InstructionLineItem 
  WHERE InstructionLineItem.finInstructionID = :finInstructionID 
  ) 
  AND InstructionLineItemRelation.instructLineItemID = InstructionLineItem.instructLineItemID