Active Users find Query

Oracle EBS Active Users/Employee Details and their Active responsibilities find Query

SELECT fu.user_name,      PAPF.FIRST_NAME||PAPF.LAST_NAME Employee_Name,      fu.EMAIL_ADDRESS User_Attached_Email,      papf.email_address Emp_attached_eamil,       frv.responsibility_name,       frv.responsibility_key,       TO_CHAR (furgd.start_date, ‘DD-MON-YYYY’) “User_Resp_START_DATE”,       TO_CHAR (furgd.end_date, ‘DD-MON-YYYY’) “User_resp_END_DATE”,       fu.start_date User_start_date,       fu.end_date User_End_date,       frv.start_date resp_start_date,       frv.End_date resp_End_date,       PAPF.effective_start_date Emp_start_date,       PAPF.EFFECTIVE_END_DATE Emp_end_date    FROM apps.fnd_user fu,  apps.fnd_user_resp_groups_direct furgd,  apps.fnd_responsibility_vl frv,   APPS.PER_ALL_PEOPLE_F PAPFWHERE fu.user_id                     = furgd.user_idAND furgd.responsibility_id          = frv.responsibility_idand upper(frv.RESPONSIBILITY_NAME)…