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
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.
FROM per_all_people_f papf
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)
WHERE assignment_id = paaf.assignment_id)