Monday, July 23, 2012

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
             )

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect