SELECT
  tpv1.typicalPictureVersionID,
  tpv1.typicalPictureID,
  tpv1.name,
  tpv1.typicalPictureVersionNumber,
  tpv1.versionStatus,
  tpv1.fromDate,
  tpv1.toDate,
  tpv1.dateCreated,
  tpv1.createdBy,
  tpv1.typicalAnswerData,
  tpv1.comments,
  tpv1.versionNo
INTO
  :typicalPictureVersionID,
  :typicalPictureID,
  :name,
  :typicalPictureVersionNumber,
  :versionStatus,
  :fromDate,
  :toDate,
  :dateCreated,
  :createdBy,
  :typicalAnswerData,
  :comments,
  :versionNo 
FROM
  TypicalPictureVersion tpv1,
  TPQuestionnaireLink 
WHERE tpv1.typicalPictureVersionID = TPQuestionnaireLink.typicalPictureVersionID 
  AND TPQuestionnaireLink.questionnaireVersionID = :questionnaireVersionID 
  AND tpv1.typicalPictureVersionNumber = 
  ( 
  SELECT
    MAX(typicalPictureVersionNumber) 
  FROM
    TypicalPictureVersion tpv2 
  WHERE tpv2.versionStatus = :versionStatus 
    AND tpv1.typicalPictureID = tpv2.typicalPictureID 
  )