SELECT
  COUNT(*)
INTO
  :count 
FROM
  TypicalPictureVersion 
WHERE UPPER(name) = :name 
  AND typicalPictureVersionID IN 
  ( 
  SELECT
    typicalPictureVersionID 
  FROM
    TPQuestionnaireLink 
  WHERE questionnaireVersionID = :questionnaireVersionID 
  )