| Operation Details |  |
| Description: | Reads closure reason, date and comments. |
| Sterotype: | ns |
| SQL | |
SELECT CaseClosure.reasonCode, CaseClosure.closureDate, Note.notesText INTO :reasonCode, :closureDate, :notesText FROM CaseClosure, CaseNote, Note WHERE CaseClosure.caseID = :caseID AND CaseNote.caseID = :caseID AND Note.noteID = CaseNote.noteID |