Operation Details
Description: Method to read the Plan Item Approval Check details and Plan Item Type details for the PIApprovalCheck id that is given as input.
Sterotype: ns
SQL 
SELECT
  PlanItemApprovalCheck.typeCode,
  PlanItemApprovalCheck.appliesToAllInd,
  PlanItemApprovalCheck.userName,
  PlanItemApprovalCheck.description,
  PlanItemApprovalCheck.percentage,
  PlanItem.name,
  PlanItemApprovalCheck.estimatedCost,
  PlanItemApprovalCheck.statusCode,
  PlanItemApprovalCheck.planItemID,
  PlanItemApprovalCheck.planItemApprovalCheckID,
  PlanItemApprovalCheck.versionNo
INTO
  :typeCode,
  :appliesToAllInd,
  :userName,
  :description,
  :percentage,
  :planItemName,
  :estimatedCost,
  :statusCode,
  :planItemID,
  :planItemApprovalCheckID,
  :versionNo 
FROM
  PlanItemApprovalCheck 
  
  LEFT OUTER JOIN
  
  PlanItem 
  ON PlanItem.planItemID = PlanItemApprovalCheck.planItemID 
WHERE PlanItemApprovalCheck.planItemApprovalCheckID = :planItemApprovalCheckID