Operation Details |
Description: | Performs a narrow read on the Appeal entity for use when modifying a judicial review. |
Sterotype: | ns |
SQL |
SELECT Appeal.appealID, Appeal.caseID, Appeal.comments, Appeal.versionNo, CaseHeader.receivedDate, CaseHeader.versionNo INTO :appealID, :caseID, :comments, :versionNo, :receivedDate, :caseHeaderVersionNo FROM Appeal, CaseHeader WHERE Appeal.caseID = CaseHeader.caseID AND Appeal.caseID = :caseID |