Operation Details
Description: Reads service plan delivery closure details.
Sterotype: ns
SQL 
SELECT
  CaseClosure.caseClosureID,
  CaseClosure.reasonCode,
  CaseClosure.versionNo,
  CaseNote.caseNoteID,
  Note.notesText
INTO
  :caseClosureID,
  :reasonCode,
  :caseClosureVersionNo,
  :caseNoteID,
  :notesText 
FROM
  CaseClosure,
  CaseNote,
  Note 
WHERE CaseClosure.caseID = :caseID 
  AND CaseNote.caseNoteID = CaseClosure.notesID 
  AND Note.noteID = CaseNote.noteID