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