Operation Details
Description: Retrieves details of all case approval checks for the specified product. This will not include user-product approval types.
Sterotype: nsmulti
SQL 
SELECT
  caseApprovalCheckID,
  typeCode,
  percentage,
  estimatedCost,
  productID,
  statusCode,
  comments,
  versionNo
INTO
  :caseApprovalCheckID,
  :typeCode,
  :percentage,
  :estimatedCost,
  :productID,
  :statusCode,
  :comments,
  :versionNo
FROM
  CaseApprovalCheck 
WHERE productID = :productID 
  AND organisationUnitID IS NULL 
  AND userName IS NULL