SELECT
  questionnaireVersionID,
  questionnaireID,
  name,
  type,
  questionnaireVersionNumber,
  versionStatus,
  fromDate,
  toDate
INTO
  :questionnaireVersionID,
  :questionnaireID,
  :name,
  :type,
  :version,
  :status,
  :fromDate,
  :toDate 
FROM
  QuestionnaireVersion 
WHERE questionnaireVersionID IN 
  ( 
  SELECT
    questionnaireVersionID 
  FROM
    TPQuestionnaireLink 
  WHERE typicalPictureVersionID = :typicalPictureVersionID 
  ) 
ORDER BY questionnaireVersionNumber