SELECT
AdminICEvidenceLink.shareableInd,
AdminICEvidenceLink.category,
AdminICEvidenceLink.sortOrder,
AdminICEvidenceLink.quickLinkInd,
EvidenceMetadata.participantDataInd,
EvidenceMetadata.evidenceType
INTO
:shareableInd,
:category,
:sortOrder,
:quickLinkInd,
:participantDataInd,
:evidenceType
FROM
AdminICEvidenceLink,
EvidenceMetadata
WHERE AdminICEvidenceLink.adminIntegratedCaseID = :adminIntegratedCaseID
AND EvidenceMetadata.evidenceMetadataID = AdminICEvidenceLink.evidenceMetadataID
AND EvidenceMetadata.recordStatus = :recordStatus
|