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
|