The reason why I wanted to do this is.. I wanted to minimize the usage of the view 'EmplyeeCodes'.
 Each time i used 'exists' this object is queried once... I was thinking if there is way I can check all the condition with one select.

Unfortunately, I was not able to think a way of doing this.

Thanks.