See query here http://cvs.openacs.org/cvs/openacs-4/packages/notifications/tcl/sweep-procs-postgresql.xql?revision=1.10&view=markup
It seems that this should join on cc_users to make sure the account is approved before sending notifications.