Operation Details
Description: Retrieves the duplicate details for the duplicate concern role where the status equals the status entered.
Sterotype: nsmulti
SQL 
SELECT
  ConcernRoleDuplicate.concernRoleDuplicateID,
  ConcernRoleDuplicate.duplicateConcernRoleID,
  ConcernRole.concernRoleName,
  ConcernRoleDuplicate.duplicateDate,
  ConcernRoleDuplicate.unmarkDate,
  ConcernRoleDuplicate.statusCode
INTO
  :concernRoleDuplicateID,
  :duplicateConcernRoleID,
  :concernRoleName,
  :duplicateDate,
  :unmarkDate,
  :statusCode 
FROM
  
  ( 
  SELECT
    ConcernRoleDuplicate.concernRoleDuplicateID,
    ConcernRoleDuplicate.duplicateConcernRoleID,
    ConcernRoleDuplicate.originalConcernRoleID,
    ConcernRoleDuplicate.duplicateDate,
    ConcernRoleDuplicate.unmarkDate,
    ConcernRoleDuplicate.statusCode 
  FROM
    ConcernRoleDuplicate 
  WHERE ConcernRoleDuplicate.duplicateConcernRoleID = :concernRoleID 
    AND ConcernRoleDuplicate.statusCode = :statusCode 
  ) ConcernRoleDuplicate INNER JOIN
  
  ConcernRole 
  ON ConcernRole.concernRoleID = ConcernRoleDuplicate.originalConcernRoleID