| Operation Details |  |
| Description: | Join across CaseNominee and CaseParticipantRole. |
| Sterotype: | ns |
| SQL | |
SELECT CaseParticipantRole.fromDate, CaseParticipantRole.toDate INTO :fromDate, :toDate FROM CaseNominee, CaseParticipantRole WHERE CaseNominee.caseNomineeID = :caseNomineeID AND CaseNominee.caseParticipantRoleID = CaseParticipantRole.caseParticipantRoleID AND CaseParticipantRole.typeCode = :caseParticipantRoleType |