Operation Details |
Description: | Reads servicePlanID by servicePlanType and statusCode. |
Sterotype: | ns |
SQL |
SELECT servicePlanID INTO :servicePlanID FROM ServicePlan WHERE servicePlanType = :servicePlanType AND recordStatus = :recordStatus |
Operation Details |
Description: | Reads servicePlanID by servicePlanType and statusCode. |
Sterotype: | ns |
SQL |
SELECT servicePlanID INTO :servicePlanID FROM ServicePlan WHERE servicePlanType = :servicePlanType AND recordStatus = :recordStatus |