Operation Details
Description: Searches for users based on email address. @param key Email address. @return Users that have the email address.
Sterotype: nsmulti
SQL 
SELECT
  userName
INTO
  :userName 
FROM
  EmailAddress,
  Users 
WHERE EmailAddress.emailAddressID = Users.businessEmailID 
  AND upper(EmailAddress.emailAddress) = :emailAddress 
  AND EmailAddress.statusCode = :recordStatus