Operation Details
Description: Searches for existing concernRoles based on an email address.
Sterotype: nsmulti
SQL 
SELECT
  concernRoleID
INTO
  :concernRoleID 
FROM
  EmailAddress,
  ConcernRoleEmailAddress 
WHERE EmailAddress.emailAddressID = ConcernRoleEmailAddress.emailAddressID 
  AND upper(EmailAddress.emailAddress) = :emailAddress 
  AND EmailAddress.statusCode = :recordStatus