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