SELECT
  COUNT(*)
INTO
  :count 
FROM
  TextTranslation TT,
  LocalizableText LT
WHERE 
  localeCode = :localeCode AND
  groupCode= :groupCode AND
  shortText= :name AND
  TT.localizableTextID=LT.localizableTextID