Database SQL Operation: DeterminationDelivery.readInitialDCDPAndDDIDsByAssessment
Description: | |
Sterotype: | ns |
SELECT
effectiveDate,
determinationDeliveryID,
determinationConfigID,
determinationPackageVersionID
INTO
:effectiveDate,
:determinationDeliveryID,
:determinationConfigID,
:determinationPackageVersionID
FROM
DeterminationDelivery
WHERE createdDateTime =
(
SELECT
MIN(createdDateTime)
FROM
DeterminationDelivery
WHERE assessmentCaseID = :assessmentCaseID
)
AND assessmentCaseID = :assessmentCaseID
|