| 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
(
typeCode = :typeCode
)
AND recordStatus = :recordStatus
|