SELECT evidenceDescriptorID, caseID, participantID, statusCode, receivedDate, effectiveFrom, correctionSetID, successionID, relatedID, evidenceType, pendingRemovalInd, pendingUpdateInd,  newInd, approvalRequestedInd, sharedInstanceID, sharedInd, changeReceivedDate, evidenceActivationDate, sharedUnchangedInd, sourceCaseID, changeReason, externalSourceCaseInd, 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 caseID = :caseID  AND sharedInstanceID = :sharedInstanceID