Operation Details
Description:  
Sterotype: nsmulti
SQL 
SELECT
evidenceDescriptorID,
evidenceType,
correctionSetID,
successionID,
participantID,
effectiveFrom,
statusCode,
receivedDate,
changeReason,
pendingRemovalInd,
versionNo
INTO 
:evidenceDescriptorID,
:evidenceType,
:correctionSetID,
:successionID,
:participantID,
:effectiveFrom,
:statusCode,
:receivedDate,
:changeReason,
:pendingRemovalInd,
:versionNo
FROM
EvidenceDescriptor
WHERE
caseID = :caseID AND
(statusCode = :statusCode1 OR
(statusCode = :statusCode2 AND
pendingRemovalInd = :pendingRemovalInd))