Operation Details
Description:  
Sterotype: nsmulti
SQL 
SELECT
  DeterminationPackageVersion.determinationPackageVersionID,
  determinationPackageID,
  determinationConfigID,
  comments,
  minAge,
  maxAge,
  gender,
  productID,
  fromDate,
  toDate,
  determinationPkgVersionNumber,
  versionStatus,
  name,
  createdBy,
  dateCreated
INTO
  :determinationPackageVersionID,
  :determinationPackageID,
  :determinationConfigID,
  :comments,
  :minAge,
  :maxAge,
  :gender,
  :productID,
  :fromDate,
  :toDate,
  :determinationPkgVersionNumber,
  :versionStatus,
  :name,
  :createdBy,
  :dateCreated 
FROM
  DeterminationPackageVersion,
  DPQuestionnaireLink 
WHERE DeterminationPackageVersion.determinationPackageVersionID = DPQuestionnaireLink.determinationPackageVersionID 
  AND versionStatus = :versionStatus 
  AND questionnaireVersionID = :questionnaireVersionID