| Operation Details |  |
| Description: | Reads service plan type for the service plan delivery. |
| Sterotype: | ns |
| SQL | |
SELECT ServicePlan.servicePlanType INTO :servicePlanType FROM ServicePlanDelivery, ServicePlan WHERE ServicePlanDelivery.caseID = :caseID AND ServicePlan.servicePlanID = ServicePlanDelivery.servicePlanID |