Operation Details |
Description: | Reads the date, status and template ID of an attachment. |
Sterotype: | ns |
SQL |
SELECT HearingDecisionAttachmentLink.attachmentDate, HearingDecisionAttachmentLink.recordStatus, HearingDecisionAttachmentLink.documentTemplateID, HearingDecisionAttachmentLink.versionNo INTO :attachmentDate, :recordStatus, :documentTemplateID, :versionNo FROM HearingDecisionAttachmentLink WHERE attachmentLinkID = :attachmentLinkID |