Operation Details
Description: Reads the attachment name and contents for downloading.
Sterotype: ns
SQL 
SELECT
  attachmentName,
  attachmentContents
INTO
  :attachmentName,
  :attachmentContents 
FROM
  Attachment,
  HearingDecisionAttachmentLink 
WHERE Attachment.attachmentID = HearingDecisionAttachmentLink.attachmentID 
  AND HearingDecisionAttachmentLink.attachmentLinkID = :attachmentLinkID