Operation Details
Description: Searches for concernRoles that have an active email address that matches the key passed in. The search is not case sensitive.
Sterotype: nsmulti
SQL 
SELECT
  concernRoleID
INTO
  :concernRoleID 
FROM
  EmailAddress,
  ConcernRoleEmailAddress 
WHERE EmailAddress.emailAddressID = ConcernRoleEmailAddress.emailAddressID 
  AND upper(EmailAddress.emailAddress) = :emailAddress 
  AND EmailAddress.statusCode = :statusCode