Operation Details
Description: Counts active contract text records in specified language for a goal.
Sterotype: ns
SQL 
SELECT
  COUNT (*)
INTO
  :recordCount 
FROM
  GoalContractText,
  ContractText 
WHERE 
  (
    GoalContractText.goalID = :goalID 
    AND ContractText.contractTextID = GoalContractText.contractTextID 
    AND ContractText.languageCode = :languageCode 
    AND ContractText.recordStatus = :recordStatus 
  )