like Sue_H, i would have the procedure send the email. if you are reusing the procedure elsewhere, add an optiona parameter with a default, like @sendEmailNotification int=0
it looks like a simple IF EXISTS would work; something like this:
IF EXISTS(SELECT 1 FROM X_SOPMOP_Link_2 where NOTICE_SENT=0)
AND @sendEmailNotification >0
BEGIN
--the exact same send email code goes here.
END
Lowell