Operation Details
Description:  
Sterotype: ns
SQL 
SELECT
  evidenceDescriptorID,
  caseID,
  participantID,
  statusCode,
  receivedDate,
  effectiveFrom,
  correctionSetID,
  successionID,
  relatedID,
  evidenceType,
  pendingRemovalInd,
  pendingUpdateInd,
  newInd,
  approvalRequestedInd,
  sharedInstanceID,
  sharedInd,
  changeReceivedDate,
  evidenceActivationDate,
  sharedUnchangedInd,
  sourceCaseID,
  versionNo
INTO
  :evidenceDescriptorID,
  :caseID,
  :participantID,
  :statusCode,
  :receivedDate,
  :effectiveFrom,
  :correctionSetID,
  :successionID,
  :relatedID,
  :evidenceType,
  :pendingRemovalInd,
  :pendingUpdateInd,
  :newInd,
  :approvalRequestedInd,
  :sharedInstanceID,
  :sharedInd,
  :changeReceivedDate,
  :evidenceActivationDate,
  :sharedUnchangedInd,
  :sourceCaseID,
  :versionNo 
FROM
  EvidenceDescriptor 
WHERE successionID = :successionID 
  AND statusCode = :statusCode 
  AND effectiveFrom = :effectiveFrom