| Operation Details |  |
| Description: | Counts the number of evidence type versions with the specified status and effecive date equal or greater (after) the specified date. |
| Sterotype: | ns |
| SQL | |
SELECT
count(*)
INTO
:counter
FROM
EvidenceTypeVersionDef
WHERE
EvidenceTypeVersionDef.evidenceTypeDefID = :evidenceTypeDefID
AND EvidenceTypeVersionDef.recordStatus <> :recordStatus
|