Operation Details
Description: This method returns the the details of the spouse of a non parent caretaker relative within the household.
Sterotype: ns
SQL 
SELECT
  HouseholdRelationship.evidenceID,
  ConcernRoleRelationship.concernRoleID,
  ConcernRoleRelationship.relConcernRoleID
INTO
  :evidenceID,
  :nPCRConcernRoleID,
  :concernRoleID 
FROM
  HouseholdRelationship,
  ConcernRoleRelationship 
WHERE HouseholdRelationship.evidenceID = :evidenceID 
  AND HouseholdRelationship.nonParentCareRelInd = :nonParentCareRelInd 
  AND ConcernRoleRelationship.concernRoleRelationshipID = HouseholdRelationship.concernRoleRelationshipID 
  AND ConcernRoleRelationship.relationshipType = :relationshipType