Operation Details
Description:  
Sterotype: nsmulti
SQL 
SELECT
  TypicalPictureVersion.typicalPictureVersionID,
  TypicalPictureVersion.typicalPictureID,
  TypicalPictureVersion.name,
  TypicalPictureVersion.typicalPictureVersionNumber,
  TypicalPictureVersion.versionStatus,
  TypicalPictureVersion.fromDate,
  TypicalPictureVersion.toDate,
  TypicalPictureVersion.dateCreated,
  TypicalPictureVersion.createdBy,
  TypicalPictureVersion.typicalAnswerData,
  TypicalPictureVersion.comments,
  TypicalPictureVersion.versionNo
INTO
  :typicalPictureVersionID,
  :typicalPictureID,
  :name,
  :typicalPictureVersionNumber,
  :versionStatus,
  :fromDate,
  :toDate,
  :dateCreated,
  :createdBy,
  :typicalAnswerData,
  :comments,
  :versionNo 
FROM
  TypicalPictureVersion,
  TPQuestionnaireLink 
WHERE TPQuestionnaireLink.questionnaireVersionID = :questionnaireVersionID 
  AND TPQuestionnaireLink.typicalPictureVersionID = TypicalPictureVersion.typicalPictureVersionID 
  AND TypicalPictureVersion.versionStatus = :versionStatus