Operation Details
Description: Return the set of evidence control records associated with a case, run and PDM/AR flag.
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,
     PDMRunConfig rc

WHERE
          cc.caseID = :caseID
AND  cc.runID = :runID
AND  cc.pdmRunCaseControlID = ec.pdmRunCaseControlID
AND  cc.runID = rc.runID
AND  rc.annualRenewalInd = :annualRenewalInd

ORDER BY ec.evidenceDescriptorID ASC