Database SQL Operation: DeterminationDelivery.readIDByStatusEffectiveDateTypeAndAssessment
Description: | To search for the completed determination delivery which has same effective date for the assessment |
Sterotype: | ns |
SELECT
determinationDeliveryID
INTO
:determinationDeliveryID
FROM
DeterminationDelivery
WHERE assessmentCaseID =
(
SELECT
assessmentCaseID
FROM
DeterminationDelivery
WHERE determinationDeliveryID = :determinationDeliveryID
)
AND status = :status
AND effectiveDate = :effectiveDate
AND determinationConfigID =
(
SELECT
determinationConfigID
FROM
DeterminationDelivery
WHERE determinationDeliveryID = :determinationDeliveryID
)
|