SELECT
  FinancialInstruction.finInstructionID
INTO
  :finInstructionID 
FROM
  InstructionLineItem,
  FinancialInstruction 
WHERE InstructionLineItem.instructLineItemID IN 
  ( 
  SELECT
    AllocationLine.instructLineItemID 
  FROM
    AllocationLine 
  WHERE AllocationLine.relatedLineItemID IN 
    ( 
    SELECT
      InstructionLineItem.instructLineItemID 
    FROM
      InstructionLineItem 
    WHERE InstructionLineItem.finInstructionID = :financialInstructionID 
    ) 
  ) 
  AND FinancialInstruction.finInstructionID = InstructionLineItem.finInstructionID 
ORDER BY FinancialInstruction.postingDate