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