| Operation Details |  |
| Description: | Reads non-cancelled and non-superseded evidence details by CaseID |
| Sterotype: | nsmulti |
| SQL | |
SELECT evidenceDescriptorID, evidenceType, participantID INTO :evidenceDescriptorID, :evidenceType, :participantID FROM EvidenceDescriptor WHERE caseID = :caseID AND statusCode <> :statusCode1 AND statusCode <> :statusCode2 |