Operation Details
Description: Method searches for unique case decisions for a specific program and check eligibility process
Sterotype: nsmulti
SQL 
SELECT
  DISTINCT(EligibilityDecisions.caseDecisionID)
INTO
  :caseDecisionID 
FROM
  EligibilityDecisions 
WHERE EligibilityDecisions.caseDecisionSetInstanceID = :caseDecisionSetInstanceID 
  AND EligibilityDecisions.productID IN 
  ( 
  SELECT
    Product.productID 
  FROM
    Product 
  WHERE Product.typeCode = :programTypeCode 
  )