SELECT
CaseNominee.caseNomineeID,
CaseNominee.nomineeRelationship,
CaseNominee.currencyType,
CaseNominee.versionNo,
ConcernRole.concernRoleID,
ConcernRole.concernRoleName,
ConcernRole.concernRoleType,
ConcernRole.primaryAlternateID,
CaseNominee.defaultNomInd
INTO
:caseNomineeID,
:nomineeRelationship,
:currencyType,
:versionNo,
:concernRoleID,
:concernRoleName,
:concernRoleType,
:alternateID,
:defaultNomInd
FROM
ConcernRole,
CaseNominee,
CaseParticipantRole
WHERE CaseParticipantRole.caseID = :caseID
AND CaseParticipantRole.caseParticipantRoleID = CaseNominee.caseParticipantRoleID
AND CaseNominee.nomineeRelationship = :nomineeRelationship
AND ConcernRole.concernRoleID = CaseParticipantRole.participantRoleID
AND CaseNominee.statusCode = :statusCode
|