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,
DPDecisionMatrixLink
WHERE DeterminationPackageVersion.determinationPackageVersionID = DPDecisionMatrixLink.determinationPackageVersionID
AND versionStatus = :versionStatus
AND decisionMatrixVersionID = :decisionMatrixVersionID
|