Operation Details
Description: Method searches for specific eligibility records for a specific person and check eligibility process
Sterotype: nsmulti
SQL 
SELECT
  EligibilityDecisions.eligibilityDecisionsID,
  EligibilityDecisions.caseID,
  EligibilityDecisions.concernRoleID,
  EligibilityDecisions.tagValue,
  EligibilityDecisions.decisionDate,
  EligibilityDecisions.decisionResultCode,
  EligibilityDecisions.caseDecisionSetInstanceID,
  EligibilityDecisions.caseDecisionID,
  EligibilityDecisions.productID
INTO
  :eligibilityDecisionsID,
  :caseID,
  :concernRoleID,
  :tagValue,
  :decisionDate,
  :decisionResultCode,
  :caseDecisionSetInstanceID,
  :caseDecisionID,
  :productID 
FROM
  EligibilityDecisions 
WHERE EligibilityDecisions.caseDecisionSetInstanceID = :caseDecisionSetInstanceID 
  AND EligibilityDecisions.concernRoleID = :concernRoleID 
  AND EligibilityDecisions.decisionResultCode = :decisionResultCode