Operation Details
Description: Returns the service plan deliveries for a service plan group and the associated status.
Sterotype: nsmulti
SQL 
SELECT
  SPGDeliveryLink.caseID,
  CaseHeader.statusCode
INTO
  :servicePlanDeliveryID,
  :servicePlanDeliveryStatus 
FROM
  SPGDeliveryLink,
  CaseHeader 
WHERE SPGDeliveryLink.servicePlanGroupDeliveryId = :servicePlanGroupDeliveryId 
  AND SPGDeliveryLink.caseID = CaseHeader.caseID