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