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!

Tables to be joined to per_all_people_f to find the person_id in pre-payment

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

  1. nestor

    nestor Active Member

    Messages:
    28
    Likes Received:
    1
    Trophy Points:
    90
    Please help me find a table (not view) on which i can join the per_all_people_f to find all employees in pre-payment.
     
  2. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    In your prepayment, you would have the vendor id. Look up the ap_suppliers table. There is employee_id column in the ap_suppliers table which will store the employee id.
     
  3. nestor

    nestor Active Member

    Messages:
    28
    Likes Received:
    1
    Trophy Points:
    90
    Sir, i am pertaining to Payroll pre-payment process. Thanks
     
  4. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Hmmm i wouldn't be able to say then... :)

    But i suggest looking at the tables which start from PAY_
     
  5. srinivas_apps

    srinivas_apps Active Member

    Messages:
    4
    Likes Received:
    1
    Trophy Points:
    65
    apps.per_all_people_f
    apps.per_all_assignments_f
    apps.pay_personal_payment_methods_f
    apps.pay_org_payment_methods
    apps.pay_assignment_actions
    apps.pay_payroll_actions
    apps.pay_pre_payments

    have a look at these tables u would have good idea of whats going on.....
     
  6. nestor

    nestor Active Member

    Messages:
    28
    Likes Received:
    1
    Trophy Points:
    90
    Actually these tables are not from apps schema. These are from hr. Srinivas do you have documents on which i can see the primary keys and foreign keys of this tables for join reference. Thanks
     
  7. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    nester have you tried the etrms, i think that will be of great help to you.
     
  8. nestor

    nestor Active Member

    Messages:
    28
    Likes Received:
    1
    Trophy Points:
    90
    sir, do you have some links for it?
     
  9. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
  10. nestor

    nestor Active Member

    Messages:
    28
    Likes Received:
    1
    Trophy Points:
    90
    Whooah! This is what i need sir. Thanks for such a very big help. Have a nice day sir :)
     
  11. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    You are most welcome! :)