SQL:SubGoalContractText.countBySubGoalIDContractLanguageAndStatus

Operation Details

Description:	Used to check if a sub goal has a related contract text in a specific language with a particular record status.
Sterotype:	ns

SQL

SELECT
  COUNT(*)
INTO
  :numContractTexts 
FROM
  SubGoalContractText,
  ContractText 
WHERE SubGoalContractText.subGoalID = :subGoalID 
  AND ContractText.contractTextID = SubGoalContractText.contractTextID 
  AND ContractText.languageCode = :languageCode 
  AND ContractText.recordStatus = :recordStatus

Database SQL Operation: SubGoalContractText.countBySubGoalIDContractLanguageAndStatus