Operation Details
Description: Retrieves all participant data case records linked to evidence by the record status code and shareableInd specified. The details retrieved include PDC type ID and type.
Sterotype: nsmulti
SQL
SELECT DISTINCT
  PDCTypeLink.pdcTypeID,
  PDCTypeLink.typeCode
INTO
  :pdcTypeID,
  :typeCode 
FROM
  PDCTypeLink,
  PDCEvidenceLink 
WHERE PDCTypeLink.pdcTypeID = PDCEvidenceLink.pdcTypeID 
  AND PDCEvidenceLink.shareableInd = :shareableInd