Operation Details
Description: Retrieves a list of phone details of a specified type for the specified concern role.
Sterotype: nsmulti
SQL 
SELECT
  phoneNumber.phoneCountryCode,
  phoneNumber.phoneAreaCode,
  phoneNumber.phoneNumber,
  phoneNumber.phoneExtension,
  phoneNumber.phoneNumberID,
  ConcernRolePhoneNumber.concernRolePhoneNumberID,
  ConcernRolePhoneNumber.typeCode
INTO
  :phoneCountryCode,
  :phoneAreaCode,
  :phoneNumber,
  :phoneExtension,
  :phoneNumberID,
  :concernRolePhoneNumberID,
  :typeCode 
FROM
  phoneNumber,
  ConcernRolePhoneNumber 
WHERE ConcernRolePhoneNumber.concernRoleID = :concernRoleID 
  AND ConcernRolePhoneNumber.typeCode = :typeCode 
  AND ConcernRolePhoneNumber.endDate IS NULL 
  AND phoneNumber.phoneNumberID = ConcernRolePhoneNumber.phoneNumberID