Operation Details
Description: Search for all active clauses within specified category.
Sterotype: nsmulti
SQL 
SELECT
  ClauseContractText.clauseName,
  ContractText.languageCode,
  ContractText.contractText,
  ClauseContractText.categoryCode
INTO
  :clauseName,
  :languageCode,
  :description,
  :clauseCategoryCode 
FROM
  ClauseContractText,
  ContractText 
WHERE ClauseContractText.contractTextID = ContractText.contractTextID 
  AND ContractText.recordStatus = :recordStatusCode 
  AND ClauseContractText.categoryCode = :categoryCode