This discussion is archived
4 Replies Latest reply: Aug 19, 2008 9:37 PM by Adil RSS

How do i Find the Salary table in HRMS

Adil Newbie
Currently Being Moderated
Hello ,
i need to Develop the Report for HRMS , this Report work on Monthy Basis
which shows the Employee current Month Earring and Name , Address and
which Account Salary is Dospited ,But i have no idea of HRMS , kindy
eplain me the table are use for this Report and Links between them


Thanks

Regards
  • 1. Re: How do i Find the Salary table in HRMS
    CuauhtemocAmox Journeyer
    Currently Being Moderated
    If You haven't worked with HRMS before, review the HRMS Implementation guide, available alongside the documentation for the Oracle Apps version Your are working with. There are some technical essays there that will help You understand the techical aspects of that family of modules. Also review etrm.oracle.com form some diagrams and the table definitions

    Review with the funcional if the Direct Deposit process is being run, as it prepares information for payment (per_pre_payments), both the amount and the reference to the account . The other information can be obtained from the employee, linking trough the assignment processed. It certainly requires You to consult with the people running the payroll to show You the relevant screens and dig Your way trough tables and relations.

    If Direct Deposit is not run (it should), then You'll have to look at the Payroll Run Processes, which may be a litte more complicated if You only want the net amount to deposit.

    Hint: Tables to look for:

    pay_payroll_actions
    pay_assignment_actions
    pay_pre_payments
    per_addresses
    pay_personal_payment_methods_f
    pay_external_accounts
  • 2. Re: How do i Find the Salary table in HRMS
    49133 Newbie
    Currently Being Moderated
    if not wrong Salary Amount is stored in PER_PAY_PROPOSALS table

    PAY_ELEMENT_ENTRY_VALUES_F,
    PAY_ELEMENT_TYPES_F
    PAY_INPUT_VALUES_F ,
    PAY_ELEMENT_ENTRIES_F,
    PAY_LINK_INPUT_VALUES_F
  • 3. Re: How do i Find the Salary table in HRMS
    49133 Newbie
    Currently Being Moderated
    try this query:

    SELECT papf.employee_number
    ,papf.full_name
    ,pj.NAME job
    ,haou.NAME ORGANIZATION
    ,ppp.proposed_salary_n salary
    FROM per_all_people_f papf
    ,per_all_assignments_f paaf
    ,per_jobs pj
    ,hr_all_organization_units haou
    ,per_position_definitions ppd
    ,per_all_positions pap
    ,per_pay_proposals ppp
    WHERE 1 = 1
    AND SYSDATE BETWEEN papf.effective_start_date AND papf.effective_end_date
    AND papf.current_employee_flag = 'Y'
    AND papf.employee_number IS NOT NULL
    AND paaf.person_id = papf.person_id
    AND SYSDATE BETWEEN paaf.effective_start_date AND paaf.effective_end_date
    AND paaf.job_id = pj.job_id
    AND paaf.organization_id = haou.organization_id
    AND paaf.position_id = pap.position_id
    AND pap.position_definition_id = ppd.position_definition_id
    AND ppp.pay_proposal_id = (SELECT MAX (pay_proposal_id)
    FROM per_pay_proposals
    WHERE assignment_id = paaf.assignment_id)
  • 4. Re: How do i Find the Salary table in HRMS
    Adil Newbie
    Currently Being Moderated
    Hi ,
    I try this query but can not find the data , please tell me other table's.

    Thanks