Oracle Apps HRMS Payroll's Important Joins

Important joins in Payroll.

select *
from pay_consolidation_sets pcs,pay_all_payrolls_f papf,pay_payroll_actions ppa
,pay_element_sets pes
,hr_assignment_sets has
where pcs.CONSOLIDATION_SET_ID = papf.CONSOLIDATION_SET_ID
and ppa.CONSOLIDATION_SET_ID = pcs.CONSOLIDATION_SET_ID
and pes.ELEMENT_SET_ID = ppa.ELEMENT_SET_ID
and has.ASSIGNMENT_SET_ID = ppa.ASSIGNMENT_SET_ID