Employee Person View for Reports

CREATE OR REPLACE VIEW xx_hr_user_person (user_id,
user_name,
person_id,
employee_number,
full_name,
email_address
)
AS
SELECT fu.user_id, fu.user_name, papf.person_id, papf.employee_number,
papf.full_name, papf.email_address
FROM per_all_people_f papf, fnd_user fu
WHERE papf.person_id = fu.employee_id
AND TRUNC (SYSDATE) BETWEEN papf.effective_start_date
AND papf.effective_end_date