Operation Details
Description: Count number of active clauses by name and language.
Sterotype: ns
SQL 
SELECT
  COUNT(*)
INTO
  :count 
FROM
  ClauseContractText,
  ContractText 
WHERE ContractText.contractTextID = ClauseContractText.contractTextID 
  AND ClauseContractText.clauseName = :clauseName 
  AND ContractText.languageCode = :languageCode 
  AND ContractText.recordStatus = :recordStatusCode