Operation Details
Description: Returns a list of the financial instructions that relate to the reversal instructions financial instruction ID.
Sterotype: nsmulti
SQL 
SELECT
  DISTINCT FinancialInstruction.finInstructionID
INTO
  :finInstructionID 
FROM
  InstructionLineItem,
  FinancialInstruction 
WHERE InstructionLineItem.instructLineItemID IN 
  ( 
  SELECT
    InstructionLineItemRelation.instructLineItemID 
  FROM
    InstructionLineItemRelation 
  WHERE InstructionLineItemRelation.relatedLineItemID IN 
    ( 
    SELECT
      InstructionLineItem.instructLineItemID 
    FROM
      InstructionLineItem 
    WHERE InstructionLineItem.finInstructionID = :financialInstructionID 
    ) 
  ) 
  AND InstructionLineItem.finInstructionID = FinancialInstruction.finInstructionID