SELECT
CaseNomineeProdDelPattern.caseNomineeProdDelPatternID,
CaseNomineeProdDelPattern.fromDate,
CaseNomineeProdDelPattern.toDate,
CaseNomineeProdDelPattern.productDeliveryPatternID,
CaseNomineeProdDelPattern.caseNomineeID,
CaseNomineeProdDelPattern.statusCode,
CaseNomineeProdDelPattern.versionNo
INTO
:caseNomineeProdDelPatternID,
:fromDate,
:toDate,
:productDeliveryPatternID,
:caseNomineeID,
:statusCode,
:versionNo
FROM
CaseNomineeProdDelPattern
WHERE CaseNomineeProdDelPattern.caseNomineeID = :caseNomineeID
AND CaseNomineeProdDelPattern.statusCode = :statusCode
AND
(
CaseNomineeProdDelPattern.fromDate <= :effectiveDate
)
AND
(
(
CaseNomineeProdDelPattern.toDate >= :effectiveDate
)
OR
(
CaseNomineeProdDelPattern.toDate IS NULL
)
)
|