| Operation Details |  |
| Description: | Retrieves the case type code of the Appealed case(either Product Delivery or Issue Delivery) on which the Appeal case is created. |
| Sterotype: | ns |
| SQL | |
SELECT caseTypeCode INTO :caseTypeCode FROM CaseHeader, AppealRelationship WHERE AppealRelationship.appealCaseID = :appealCaseID AND CaseHeader.caseID =AppealRelationship.caseID |