EBS : HRMS : SQL Query

 HRMS SQL Query

---Employee Tab 

select * from per_all_people_f where EMPLOYEE_NUMBER ='12'

---Employee Assignment Tab

select * from per_assignments_f where person_id=35347

---Payroll Entries Tab

select * from pay_element_entries_f where ASSIGNMENT_ID= 3539 and ELEMENT_TYPE_ID=6523

select nvl(pet1.retro_summ_ele_id, pet1.element_type_id) from pay_element_types_f pet1 where pet1.element_type_id = 647;

Important Table

pay_process_events;

PAY_RETRO_ASSIGNMENTS 

PAY_RETRO_ENTRIES

Important Standard Program

pay_in_tax_utils.get_balance_value

PAY_RETRO_PKG