X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2Fcontact.pm;h=9c83338a8780264a93445f9ef4c9a0d27f7f2dab;hb=8741aff54c6fd4a9fa8c9a1fc6da8a7e68c4b496;hp=e49f6df7719a2d3f4b6d657b7c6ab0af614ab02c;hpb=691b4de7c0a7d0e39bebe2ea7fadea5fb21b1539;p=freeside.git

diff --git a/FS/FS/contact.pm b/FS/FS/contact.pm
index e49f6df77..9c83338a8 100644
--- a/FS/FS/contact.pm
+++ b/FS/FS/contact.pm
@@ -772,8 +772,13 @@ sub by_selfservice_email {
     'table'     => 'contact_email',
     'addl_from' => ' LEFT JOIN contact USING ( contactnum ) ',
     'hashref'   => { 'emailaddress' => $email, },
-    'extra_sql' => " AND ( contact.disabled IS NULL ) ".
-                   " AND ( contact.selfservice_access = 'Y' )",
+    'extra_sql' => "
+      AND ( contact.disabled IS NULL )
+      AND EXISTS ( SELECT 1 FROM cust_contact
+                     WHERE contact.contactnum = cust_contact.contactnum
+                       AND cust_contact.selfservice_access = 'Y'
+                 )
+    ",
   }) or return '';
 
   $contact_email->contact;