Operation Details
Description: Method to get the list if the Plan Item Approval Check details and the PI type details for the user name that is passed as input.
Sterotype: nsmulti
SQL 
SELECT
  PIAC.typeCode,
  PIAC.appliesToAllInd,
  PIAC.userName,
  PIAC.description,
  PIAC.percentage,
  PI.name,
  PIAC.estimatedCost,
  PIAC.statusCode,
  PIAC.planItemID,
  PIAC.planItemApprovalCheckID,
  PIAC.versionNo
INTO
  :typeCode,
  :appliesToAllInd,
  :userName,
  :description,
  :percentage,
  :planItemName,
  :estimatedCost,
  :statusCode,
  :planItemID,
  :planItemApprovalCheckID,
  :versionNo 
FROM
  PlanItemApprovalCheck PIAC 
  
  LEFT OUTER JOIN
  
  PlanItem PI 
  ON PI.planItemID = PIAC.planItemID 
WHERE PIAC.userName = :userName