SELECT  
  ed.evidenceDescriptorID,
  ed.caseID,
  ed.participantID,
  ed.statusCode,
  ed.receivedDate,
  ed.effectiveFrom,
  ed.correctionSetID,
  ed.successionID,
  ed.relatedID,
  ed.evidenceType,
  ed.pendingRemovalInd,
  ed.pendingUpdateInd,
  ed.newInd,
  ed.approvalRequestedInd,
  ed.sharedInstanceID,
  ed.sharedInd,
  ed.changeReceivedDate,
  ed.evidenceActivationDate,
  ed.sharedUnchangedInd,
  ed.sourceCaseID,
  ed.changeReason,
  ed.externalSourceCaseInd,
  ed.versionNo
INTO
  :evidenceDescriptorID,
  :caseID,
  :participantID,
  :statusCode,
  :receivedDate,
  :effectiveFrom,
  :correctionSetID,
  :successionID,
  :relatedID,
  :evidenceType,
  :pendingRemovalInd,
  :pendingUpdateInd,
  :newInd,
  :approvalRequestedInd,
  :sharedInstanceID,
  :sharedInd,
  :changeReceivedDate,
  :evidenceActivationDate,
  :sharedUnchangedInd,
  :sourceCaseID,
  :changeReason,
  :externalSourceCaseInd,
  :versionNo  
FROM
  EvidenceDescriptor ed, 
  PDMRunCaseControl cc, 
  PDMRunEvidenceControl ec
WHERE
  cc.runID = :runID
  AND cc.caseID = :caseID
  AND cc.pdmRunCaseControlID = ec.pdmRunCaseControlID
  AND ec.evidenceDescriptorID = ed.evidenceDescriptorID
  AND ec.autoAppliedDate is NULL
  AND ec.contestedDate is NULL
ORDER BY ed.evidenceDescriptorID ASC