Operation Details
Description: This method searches for all evidence descriptor records for a given succession id and either one of two status codes.
Sterotype: nsmulti
SQL 
SELECT
  EvidenceDescriptor.evidenceDescriptorID,
  EvidenceDescriptor.caseID,
  EvidenceDescriptor.participantID,
  EvidenceDescriptor.statusCode,
  EvidenceDescriptor.receivedDate,
  EvidenceDescriptor.effectiveFrom,
  EvidenceDescriptor.correctionSetID,
  EvidenceDescriptor.successionID,
  EvidenceDescriptor.relatedID,
  EvidenceDescriptor.evidenceType,
  EvidenceDescriptor.pendingRemovalInd,
  EvidenceDescriptor.pendingUpdateInd,
  EvidenceDescriptor.newInd,
  EvidenceDescriptor.approvalRequestedInd,
  EvidenceDescriptor.sharedInstanceID,
  EvidenceDescriptor.sharedInd,
  EvidenceDescriptor.changeReceivedDate,
  EvidenceDescriptor.evidenceActivationDate,
  EvidenceDescriptor.sharedUnchangedInd,
  EvidenceDescriptor.sourceCaseID,
  EvidenceDescriptor.changeReason,
  EvidenceDescriptor.externalSourceCaseInd,
  EvidenceDescriptor.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 
WHERE successionID = :successionID 
  AND 
  (
    statusCode = :statusCode1 
    OR statusCode = :statusCode2 
  )