Operation Details
Description:  
Sterotype: ns
SQL 
SELECT
  typicalPictureVersionID,
  typicalPictureID,
  name,
  typicalPictureVersionNumber,
  versionStatus,
  fromDate,
  toDate,
  dateCreated,
  createdBy,
  typicalAnswerData,
  comments,
  versionNo
INTO
  :typicalPictureVersionID,
  :typicalPictureID,
  :name,
  :typicalPictureVersionNumber,
  :versionStatus,
  :fromDate,
  :toDate,
  :dateCreated,
  :createdBy,
  :typicalAnswerData,
  :comments,
  :versionNo 
FROM
  TypicalPictureVersion 
WHERE typicalPictureID = 
  ( 
  SELECT
    DISTINCT(TP1.typicalPictureID) 
  FROM
    TypicalPictureVersion TP1 
  WHERE TP1.typicalPictureVersionID = :typicalPictureVersionId 
  ) 
  AND typicalPictureVersionNumber = :versionNumber