Operation Details
Description: Reads the details of a clause.
Sterotype: ns
SQL 
SELECT
  ClauseContractText.clauseName,
  ClauseContractText.categoryCode,
  ContractText.languageCode,
  ContractText.contractText,
  ClauseContractText.comments,
  ContractText.recordStatus,
  ContractText.versionNo,
  ClauseContractText.versionNo
INTO
  :clauseName,
  :categoryCode,
  :languageCode,
  :contractText,
  :comments,
  :recordStatusCode,
  :contractTextVersionNo,
  :clauseContractTextVersionNo 
FROM
  ClauseContractText,
  ContractText 
WHERE ContractText.contractTextID = ClauseContractText.contractTextID 
  AND ClauseContractText.clauseContractTextID = :clauseContractTextID