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
AND statusCode = :statusCode
|