Database SQL Operation: HouseholdRelationship.searchExistingConcernRoleRelationships
Description: | This method searches for existing concern role relationships between household members. |
Sterotype: | nsmulti |
SELECT
concernRoleRelationshipID,
concernRoleRecipRelationID
INTO
:concernRoleRelationshipID,
:concernRoleRecipRelationID
FROM
ConcernRoleRelationship,
CaseParticipantRole
WHERE ConcernRoleRelationship.concernRoleID = :participantRoleID
AND ConcernRoleRelationship.relconcernRoleID = CaseparticipantRole.participantRoleID
AND CaseParticipantRole.caseParticipantRoleID = :caseParticipantRoleID
|