SQL:PlanItemContractText.countByPlanItemIDLanguageAndRecordStatus

Operation Details

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

SQL

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

Database SQL Operation: PlanItemContractText.countByPlanItemIDLanguageAndRecordStatus