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

Oracle Apps HRMS Employee Salary History

Employee's salary History with reasons.

SELECT pro.ROWID, pro.pay_proposal_id, pro.business_group_id,
pro.assignment_id, pro.performance_review_id, prv.review_date,
hl2.meaning, pro.proposed_salary, TO_NUMBER (pro.proposed_salary),
pro.change_date, pro.proposal_reason, hl1.meaning,
pro.last_change_date, pro.next_sal_review_date, pro.forced_ranking,
pro.attribute_category, pro.attribute1, pro.attribute2,
pro.multiple_components,
pro.approved, pro.comments, pro.object_version_number,
pro.last_update_date, pro.last_updated_by, pro.last_update_login,
pro.created_by, pro.creation_date
FROM hr_lookups hl1,
hr_lookups hl2,
per_performance_reviews prv,
per_pay_proposals pro
WHERE pro.performance_review_id = prv.performance_review_id(+)
AND hl2.lookup_code(+) = prv.performance_rating
AND hl2.lookup_type(+) = 'PERFORMANCE_RATING'
AND hl1.lookup_code(+) = pro.proposal_reason
AND hl1.lookup_type(+) = 'PROPOSAL_REASON'

Oracle Apps HRMS lookups details

Oracle HRMS lookups details.

SELECT LOOKUP_CODE,MEANING,LOOKUP_TYPE
FROM FND_COMMON_LOOKUPS
WHERE APPLICATION_ID = 800

Oracle Apps HRMS Deductions and Earnings.

How to find out the payment elements deductions and Earnings ?

SELECT DISTINCT PET.ELEMENT_NAME,PET.ELEMENT_TYPE_ID,PET.EFFECTIVE_START_DATE,PET.REPORTING_NAME,PEC.CLASSIFICATION_NAME
FROM PAY_ELEMENT_CLASSIFICATIONS PEC, PAY_ELEMENT_TYPES_F PET
WHERE PEC.CLASSIFICATION_ID = PET.CLASSIFICATION_ID
AND PEC.CLASSIFICATION_NAME IN ('Earnings','Tax Deductions')
ORDER BY PEC.CLASSIFICATION_NAME