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