Operation Details
Description: Read the record given by the unique ID in the key and return all of the details along with the type code for the Service Plan Group.
Sterotype: ns
SQL 
SELECT
  ServicePlanGroupApprovalCheck.typeCode,
  ServicePlanGroupApprovalCheck.appliesToAllInd,
  ServicePlanGroupApprovalCheck.userName,
  ServicePlanGroupApprovalCheck.description,
  ServicePlanGroupApprovalCheck.percentage,
  ServicePlanGroup.servicePlanGroupName,
  ServicePlanGroupApprovalCheck.estimatedCost,
  ServicePlanGroupApprovalCheck.statusCode,
  ServicePlanGroupApprovalCheck.servicePlanGroupID,
  ServicePlanGroupApprovalCheck.servicePlanGroupApprovalChkID,
  ServicePlanGroupApprovalCheck.versionNo
INTO
  :typeCode,
  :appliesToAllInd,
  :userName,
  :description,
  :percentage,
  :servicePlanGroupTypeCode,
  :estimatedCost,
  :statusCode,
  :servicePlanGroupID,
  :servicePlanGroupApprovalChkID,
  :versionNo 
FROM
  ServicePlanGroupApprovalCheck 
  
  LEFT OUTER JOIN
  
  ServicePlanGroup 
  ON ServicePlanGroup.servicePlanGroupID = ServicePlanGroupApprovalCheck.servicePlanGroupID 
WHERE ServicePlanGroupApprovalCheck.servicePlanGroupApprovalChkID = :servicePlanGroupApprovalChkID