Operation Details
Description: To retrieve the preferred Language and participant role type using the participantRoleID
Sterotype: ns
SQL 
SELECT
  ConcernRole.concernRoleType,
  ConcernRole.preferredLanguage,
  ConcernRole.primaryAddressID,
  ConcernRole.primaryPhoneNumberID,
  Address.addressData,
  ConcernRoleAddress.typeCode
INTO
  :concernRoleType,
  :preferredLanguage,
  :primaryAddressID,
  :primaryPhoneNumberID,
  :addressData,
  :typeCode 
FROM
  ConcernRole,
  Address,
  ConcernRoleAddress 
WHERE ConcernRole.concernRoleID = :concernRoleID 
  AND Address.addressID = ConcernRole.primaryAddressID 
  AND ConcernRoleAddress.concernRoleID = ConcernRole.concernRoleID 
  AND ConcernRoleAddress.addressID = ConcernRole.primaryAddressID