Operation Details
Description: Returns phone details for the specified concern role if their duplicate number, type, and extension is found.
Sterotype: nsmulti
SQL 
SELECT
  ConcernRolePhoneNumber.concernRolePhoneNumberID,
  phoneNumber.phoneAreaCode,
  phoneNumber.phoneNumber,
  ConcernRolePhoneNumber.typeCode,
  ConcernRolePhoneNumber.startDate,
  ConcernRolePhoneNumber.endDate,
  phoneNumber.statusCode,
  phoneNumber.phoneExtension,
  phoneNumber.phoneNumberID
INTO
  :concernRolePhoneNumberID,
  :phoneAreaCode,
  :phoneNumber,
  :typeCode,
  :startDate,
  :endDate,
  :statusCode,
  :phoneExtension,
  :phoneNumberID 
FROM
  phoneNumber,
  ConcernRolePhoneNumber 
WHERE ConcernRolePhoneNumber.concernRoleID = :concernRoleID 
  AND phoneNumber.phoneNumberID = ConcernRolePhoneNumber.phoneNumberID 
  AND phoneNumber.phoneNumber = :phoneNumber 
  AND 
  (
    
    (
      phoneNumber.phoneExtension = :phoneExtension 
    ) 
    OR 
    (
      phoneNumber.phoneExtension IS NULL 
      AND :phoneExtension IS NULL 
    ) 
  ) 
  AND phoneNumber.statusCode = :statusCode 
  AND ConcernRolePhoneNumber.typeCode = :typeCode