Operation Details
Description: Method to return the existing relationship details of relationship type, related member and nonParentCareRelativeInd for a household member.
Sterotype: nsmulti
SQL 
SELECT
  ConcernRoleRelationship.relConcernRoleID,
  ConcernRole.concernRoleName,
  ConcernRoleRelationship.relationshipType,
  HouseholdRelationship.nonParentCareRelInd
INTO
  :relParticipantRoleID,
  :relParticipantName,
  :relationshipTypeDesc,
  :nonParentCareRelativeIndicator 
FROM
  ConcernRoleRelationship,
  ConcernRole,
  HouseholdRelationship,
  CaseParticipantRole 
WHERE CaseParticipantRole.caseParticipantRoleID = :caseParticipantRoleID 
  AND ConcernRoleRelationship.concernRoleID = CaseParticipantRole.participantRoleID 
  AND ConcernRole.concernRoleID = ConcernRoleRelationship.relConcernRoleID 
  AND HouseholdRelationship.concernRoleRelationshipID = ConcernRoleRelationship.concernRoleRelationshipID