Operation Details
Description: Get the evidence control records associated with the specified case and run identifiers.
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
AND  cc.runID = :runID

ORDER BY ec.evidenceDescriptorID ASC