Getting the Position Name and Supervisor Id by Oracle User Login Name

SELECT

pos.name  position_name,

pa.position_id,                                               

fnd.user_name,

PA.SUPERVISOR_ID

FROM

PER_ALL_ASSIGNMENTS_F pa,

per_positions pos,

per_jobs job,

fnd_user fnd

WHERE 1=1

and pa.POSITION_ID =  pos.POSITION_ID

and pa.job_ID = job.job_id

and sysdate between pa.EFFECTIVE_START_DATE

and pa.EFFECTIVE_END_DATE

and pa.primary_flag = 'Y'

and pa.assignment_type = 'E'

and pa.person_id = fnd.employee_id

and pa.PERSON_ID = (

                                      select employee_id

                                      from fnd_user

                                      where user_name = :USERNAME

             )