Operation Details |
Description: | Returns the appeal case owner, the appeal case status and the overall deadline date for an appeal case. |
Sterotype: | ns |
SQL |
SELECT Appeal.deadlineDate, CaseHeader.ownerOrgObjectLinkID, CaseHeader.statusCode INTO :deadlineDate, :ownerOrgObjectLinkID, :statusCode FROM Appeal, CaseHeader WHERE Appeal.caseID = :caseID AND Appeal.caseID = CaseHeader.caseID |