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'
Subscribe to:
Post Comments (Atom)
I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in ORACLE HRMS TECHNICAL, kindly contact us http://www.maxmunus.com/contact
ReplyDeleteMaxMunus Offer World Class Virtual Instructor led training on ORACLE HRMS TECHNICAL We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
For Demo Contact us.
Saurabh Srivastava
MaxMunus
E-mail: saurabh@maxmunus.com
Skype id: saurabhmaxmunus
Ph:+91 8553576305 / 080 - 41103383
http://www.maxmunus.com/