SQL & PL/SQL

Hi

In the foilowing query the user id is not showing up. The reason for u.user_name(+) is that all employees of per_all_people_f will not have an FND user account

Thanks in advance

Anna

select u.user_id, p.person_id
from apps.fnd_user u,
apps.per_all_people_f p
where u.user_name(+) = upper(p.ATTRIBUTE7)
and p.person_id in ('12855', '193104', '188066', '249726', '97642')
and trunc(sysdate) between p.effective_start_date and p.effective_end_date;