1. The Forum has been upgraded to a modern and advanced system. Please read the announcement about this update.
  2. 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,890
    Likes Received:
    247
    Trophy Points:
    1,155
    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,890
    Likes Received:
    247
    Trophy Points:
    1,155
    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!!