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!

JOIN between PER_ALL_PEOPLE_F and HR_ALL_ORGANIZATION_UNITS

Discussion in 'Oracle HRMS & Payroll' started by nestor, Sep 17, 2010.

  1. nestor

    nestor Active Member

    Messages:
    28
    Likes Received:
    1
    Trophy Points:
    90
    My goal is to find the organization of each employee, does anybody know how to join PER_ALL_PEOPLE_F and HR_ALL_ORGANIZATION_UNITS for me to be able to get the organization_id and organization name of each person. Please help
     
  2. srinivas_apps

    srinivas_apps Active Member

    Messages:
    4
    Likes Received:
    1
    Trophy Points:
    65
    per_all_people_f - person_id
    per_all_assignments_f - person_id,organization_id
    hr_all_organization_units - organization_id

    assignments table is where you get the org id and join it with organization units. hope it helps.
     
    nestor likes this.
  3. nestor

    nestor Active Member

    Messages:
    28
    Likes Received:
    1
    Trophy Points:
    90
    Thank you for a helping hand even if i am not an indian. More power to you sir. I will be posting another question and i hope you'll still offer the same help :)
     
  4. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,904
    Likes Received:
    252
    Trophy Points:
    1,455
    Nester, this forum is not only for Indians, more than half members are not indians, I don't know where you got that from?
     
  5. nestor

    nestor Active Member

    Messages:
    28
    Likes Received:
    1
    Trophy Points:
    90
    Sorry for that statement sir. I just thought that most of the members are indian. I hope you guys don't get offended by that statement.
     
  6. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,904
    Likes Received:
    252
    Trophy Points:
    1,455
    Oh no need for apology... :) My apologies if my comment was harsh!
     
  7. srinivas_apps

    srinivas_apps Active Member

    Messages:
    4
    Likes Received:
    1
    Trophy Points:
    65
    any time Nestor!!