EXISTS function is failing

when I remove the condition with EXISTS function, it works but now Its failing.