Operation Details
Description: COMMENTS=Checks for duplicate product evidence approval checks on modify.
Sterotype: ns
SQL 
SELECT
  COUNT(*)
INTO
  :counter 
FROM
  EvidenceApprovalCheck 
WHERE evidenceApprovalCheckID <> :evidenceApprovalCheckID 
  AND productID = :productID 
  AND userName = :userName 
  AND recordStatus = :recordStatus