Operation Details |
Description: | Returns the case owner and prior appeal caseID for all prior appeal cases appealed on an appeal case. |
Sterotype: | nsmulti |
SQL |
SELECT AppealRelationship.caseID, CaseHeader.ownerOrgObjectLinkID INTO :caseID, :ownerOrgObjectLinkID FROM AppealRelationship, CaseHeader WHERE appealCaseID = :appealCaseID AND priorAppealCaseID = CaseHeader.caseID |