Operation Details
Description: Returns the details of a hearing decision attachment required for modification.
Sterotype: ns
SQL 
SELECT
  HearingDecisionAttachmentLink.attachmentID,
  fileReference,
  fileLocation,
  attachmentName,
  Attachment.versionNo,
  HearingDecision.versionNo
INTO
  :attachmentID,
  :documentReference,
  :documentLocation,
  :attachmentName,
  :attachmentVersionNo,
  :hearingDecisionVersionNo 
FROM
  HearingDecisionAttachmentLink,
  Attachment,
  HearingDecision 
WHERE HearingDecisionAttachmentLink.attachmentID = Attachment.attachmentID 
  AND attachmentLinkID = :attachmentLinkID 
  AND HearingDecisionAttachmentLink.hearingDecisionID = HearingDecision.hearingDecisionID