Operation Details
Description: List all service plan group approval check entries for a given username and include the service plan group type code for display purposes.
Sterotype: nsmulti
SQL 
SELECT
  SPGAC.typeCode,
  SPGAC.appliesToAllInd,
  SPGAC.userName,
  SPGAC.description,
  SPGAC.percentage,
  SPG.servicePlanGroupName,
  SPGAC.estimatedCost,
  SPGAC.statusCode,
  SPGAC.servicePlanGroupID,
  SPGAC.servicePlanGroupApprovalChkID,
  SPGAC.versionNo
INTO
  :typeCode,
  :appliesToAllInd,
  :userName,
  :description,
  :percentage,
  :servicePlanGroupTypeCode,
  :estimatedCost,
  :statusCode,
  :servicePlanGroupID,
  :servicePlanGroupApprovalChkID,
  :versionNo 
FROM
  ServicePlanGroupApprovalCheck SPGAC 
  
  LEFT OUTER JOIN
  
  ServicePlanGroup SPG 
  ON SPG.servicePlanGroupID = SPGAC.servicePlanGroupID 
WHERE SPGAC.userName = :userName