Operation Details
Description: Searches for a list of users that have an active email address that matches the email address passed in. The search is not case sensitive.
Sterotype: nsmulti
SQL 
SELECT
  userName
INTO
  :userName 
FROM
  EmailAddress,
  Users 
WHERE EmailAddress.emailAddressID = Users.businessEmailID 
  AND upper(EmailAddress.emailAddress) = :emailAddress 
  AND EmailAddress.statusCode = :statusCode