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.recordStatus = :recordStatus
  AND EvidenceTypeVersionDef.evidenceTypeDefID = :evidenceTypeDefID
  AND EvidenceTypeVersionDef.effectiveFrom >= :effectiveFrom