Operation Details
Description: COMMENTS=Retrieves details of all evidence approval checks for the specified product. This will not include user-product approval types.
Sterotype: nsmulti
SQL 
SELECT
  evidenceApprovalCheckID,
  typeCode,
  percentage,
  productID,
  comments,
  recordStatus
INTO
  :evidenceApprovalCheckID,
  :typeCode,
  :percentage,
  :productID,
  :comments,
  :recordStatus 
FROM
  EvidenceApprovalCheck 
WHERE productID = :productID 
  AND organisationUnitID IS NULL 
  AND userName IS NULL