Database SQL Operation: HearingDecisionAttachmentLink.readAttachment
Description: | Returns the details of the hearing decision attachment. |
Sterotype: | ns |
SELECT
HearingDecisionAttachmentLink.attachmentID,
fileReference,
fileLocation,
attachmentName,
HearingDecisionAttachmentLink.versionNo
INTO
:attachmentID,
:documentReference,
:documentLocation,
:attachmentName,
:versionNo
FROM
HearingDecisionAttachmentLink,
Attachment
WHERE HearingDecisionAttachmentLink.attachmentID = Attachment.attachmentID
AND attachmentLinkID = :attachmentLinkID
|