Operation Details
Description:  
Sterotype: ns
SQL 
SELECT
  determinationPackageVersionID,
  determinationPackageID,
  determinationConfigID,
  comments,
  minAge,
  maxAge,
  gender,
  productID,
  fromDate,
  toDate,
  determinationPkgVersionNumber,
  versionStatus,
  name,
  createdBy,
  dateCreated,
  flag
INTO
  :determinationPackageVersionID,
  :determinationPackageID,
  :determinationConfigID,
  :comments,
  :minAge,
  :maxAge,
  :gender,
  :productID,
  :fromDate,
  :toDate,
  :determinationPkgVersionNumber,
  :versionStatus,
  :name,
  :createdBy,
  :dateCreated,
  :flag 
FROM
  DeterminationPackageVersion 
WHERE determinationPackageID = :determinationPackageID 
  AND determinationPkgVersionNumber = 
  ( 
  SELECT
    MAX(determinationPkgVersionNumber) 
  FROM
    DeterminationPackageVersion 
  WHERE determinationPackageID = :determinationPackageID 
  )