Operation Details
Description: Return the set of records associated with a case.
Sterotype: nsmulti
SQL 
SELECT
    ec.autoAppliedDate,
	ec.contestedDate,
	ec.contestedReason,
	ec.evidenceDescriptorID,
	ec.initiallyCompatible,
	ec.pdmRunCaseControlID,
	ec.pdmRunEvidenceControlID,
       ec.versionNo
INTO
    :autoAppliedDate,
	:contestedDate,
	:contestedReason,
	:evidenceDescriptorID,
	:initiallyCompatible,
	:pdmRunCaseControlID,
	:pdmRunEvidenceControlID,
       :versionNo
FROM 
     PDMRunCaseControl cc,
	 PDMRunEvidenceControl ec
	 
WHERE
     cc.pdmRunCaseControlID = ec.pdmRunCaseControlID
AND  cc.caseID = :caseID

ORDER BY ec.evidenceDescriptorID ASC