Operation Details
Description: Reads all Representative details.
Sterotype: ns
SQL 
SELECT
  ConcernRole.concernRoleID,
  ConcernRole.primaryAddressID,
  ConcernRole.primaryPhoneNumberID,
  ConcernRole.registrationDate,
  ConcernRole.sensitivity,
  ConcernRole.prefCommMethod,
  ConcernRole.endDate,
  Representative.representativeName,
  Representative.representativeType,
  Representative.alternateID,
  Representative.versionNo,
  Representative.comments,
  Representative.paymentFrequency,
  Representative.nextPaymentDate,
  Representative.currencyType,
  Representative.methodOfPmtCode,
  Representative.dateOfBirth
INTO
  :concernRoleID,
  :primaryAddressID,
  :primaryPhoneNumberID,
  :registrationDate,
  :sensitivity,
  :preferredCommunication,
  :endDate,
  :representativeName,
  :representativeType,
  :alternateID,
  :versionNo,
  :comments,
  :paymentFrequency,
  :nextPaymentDate,
  :currencyType,
  :methodOfPmtCode,
  :dateOfBirth 
FROM
  ConcernRole,
  Representative 
WHERE ConcernRole.concernRoleID = :concernRoleID 
  AND ConcernRole.concernRoleID = Representative.concernRoleID