Operation Details
Description: list all case decision set instances, along with decisionDate and status, for a given screening case
Sterotype: nsmulti
SQL 
SELECT
  DISTINCT CaseDecisionSet.instanceID,
  CaseDecision.decisionDate,
  CaseDecision.statusCode
INTO
  :instanceID,
  :decisionDate,
  :statusCode 
FROM
  CaseDecision,
  CaseDecisionSet 
WHERE CaseDecisionSet.caseDecisionID = CaseDecision.caseDecisionID 
  AND CaseDecision.caseID IN 
  ( 
  SELECT
    caseID 
  FROM
    CaseHeader 
  WHERE CaseHeader.integratedCaseID = :caseID 
  )