Operation Details
Description: Searches for any relationships of a specific type that a household member has with other members of the household.
Sterotype: nsmulti
SQL 
SELECT
  ConcernRoleRelationship.relConcernRoleID
INTO
  :relParticipantRoleID 
FROM
  ConcernRoleRelationship,
  HouseholdRelationship 
WHERE ConcernRoleRelationship.concernRoleRelationshipID = HouseholdRelationship.concernRoleRelationshipID 
  AND ConcernRoleRelationship.concernRoleID = :participantRoleID 
  AND ConcernRoleRelationship.relationshipType = :relationshipType 
  AND ConcernRoleRelationship.statusCode = :relationshipStatusCode