Operation Details
Description:  
Sterotype: ns
SQL 
SELECT
  Person.specialInterestCode,
  Person.comments,
  Person.paymentFrequency,
  Person.nextPaymentDate,
  Person.currencyType,
  Person.methodOfPmtCode,
  Person.versionNo,
  ConcernRole.registrationDate,
  ConcernRole.sensitivity,
  ConcernRole.prefPublicOfficeID
INTO
  :specialInterestCode,
  :comments,
  :paymentFrequency,
  :nextPaymentDate,
  :currencyType,
  :methodOfPmtCode,
  :versionNo,
  :registrationDate,
  :sensitivity,
  :prefPublicOfficeID
FROM
  Person,
  ConcernRole
WHERE Person.concernRoleID = :concernRoleID 
  AND ConcernRole.concernRoleID = :concernRoleID