SELECT
CaseNomineeProdDelPattern.caseNomineeProdDelPatternID,
CaseNomineeProdDelPattern.fromDate,
CaseNomineeProdDelPattern.toDate,
CaseNomineeProdDelPattern.productDeliveryPatternID,
CaseNomineeProdDelPattern.caseNomineeID,
CaseNomineeProdDelPattern.statusCode
INTO
:caseNomineeProdDelPatternID,
:fromDate,
:toDate,
:productDeliveryPatternID,
:caseNomineeID,
:statusCode
FROM
CaseNomineeProdDelPattern
WHERE CaseNomineeProdDelPattern.caseNomineeID in
(
SELECT
caseNomineeID
FROM
CaseNominee,
CaseParticipantRole
WHERE CaseParticipantRole.caseID = :caseID
AND CaseNominee.caseParticipantRoleID = CaseParticipantRole.caseParticipantRoleID
AND CaseNominee.defaultNomInd = :defaultNomInd
)
AND CaseNomineeProdDelPattern.statusCode = :statusCode
|