Operation Details
Description: reads the list of FinInstructionID's for an integrated Case
Sterotype: nsmulti
SQL 
SELECT
  DISTINCT(InstructionLineItem.finInstructionID)
INTO
  :finInstructionID 
FROM
  CaseHeader,
  InstructionLineItem 
WHERE 
  (
    
    (
      CaseHeader.integratedCaseID = :caseID 
    ) 
    AND 
    (
      CaseHeader.concernRoleID = :concernRoleID 
      OR :concernRoleIDIsNull <> '0' 
    ) 
  ) 
  AND 
  (
    InstructionLineItem.caseID = CaseHeader.caseID 
  ) 
  AND InstructionLineItem.effectiveDate >= :effectiveDateFrom 
  AND InstructionLineItem.effectiveDate <= :effectiveDateTo