1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Query To get List of Employees which Dont have Supervisors

Discussion in 'Oracle Apps Technical' started by jagadekara, Jan 2, 2015.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    The following is a Query To get List of Employees which Dont have Supervisors.


    Code (SQL):
    SELECT ppf.full_name
      FROM per_all_people_f ppf
          ,per_all_assignments_f paaf
     WHERE 1=1
       AND ppf.person_id=paaf.person_id
       AND ppf.employee_number IS NOT NULL
       AND paaf.supervisor_id IS  NULL
    --   AND ppf.person_id=69859
       AND sysdate BETWEEN paaf.effective_start_date AND paaf.effective_end_date
    Let me know If I am wrong...