Operation Details
Description: Searches for a duplicate Relationship based on the relationship details
Sterotype: nsmulti
SQL 
SELECT
  concernRoleID,
  concernRoleType,
  relConcernRoleID,
  relConcernRoleType,
  startDate,
  endDate,
  relationshipType,
  relEndReasonCode,
  statusCode,
  comments,
  concernRoleRelationshipID,
  concernRoleRecipRelationID,
  versionNo
INTO
  :concernRoleID,
  :concernRoleType,
  :relConcernRoleID,
  :relConcernRoleType,
  :startDate,
  :endDate,
  :relationshipType,
  :relEndReasonCode,
  :statusCode,
  :comments,
  :concernRoleRelationshipID,
  :concernRoleRecipRelationID,
  :versionNo 
FROM
  ConcernRoleRelationship 
WHERE concernRoleID = :concernRoleID 
  AND relConcernRoleID = :relConcernRoleID 
  AND relationshipType = :relationshipType 
  AND 
  (
    
    (
      endDate >= :startDate 
      OR endDate IS NULL 
    ) 
    AND statusCode = :statusCode 
    AND 
    (
      startDate <= :endDate 
      OR :endDate IS NULL 
    ) 
  )