eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CWB_PERSON_INFO_PKG dependencies on PER_PERFORMANCE_REVIEWS

Line 647: from per_performance_reviews rtg1

643: ,(select rtg1.review_date review_date
644: ,rtg1.performance_rating performance_rating
645: ,rtg1.person_id person_id
646: ,apr.appraisal_id
647: from per_performance_reviews rtg1
648: ,per_events evt1
649: ,per_appraisals apr
650: where rtg1.event_id = evt1.event_id (+)
651: and rtg1.review_date <= p_effective_date

Line 695: from per_performance_reviews rtg2

691: and ppf.person_id = perf.person_id (+)
692: and nvl(perf.review_date, to_date('4712/12/31', 'yyyy/mm/dd')) =
693: (select nvl(max(rtg2.review_date),to_date('4712/12/31',
694: 'yyyy/mm/dd'))
695: from per_performance_reviews rtg2
696: ,per_events evt2
697: where rtg2.person_id = ppf.person_id
698: and rtg2.review_date <= p_effective_date
699: and rtg2.event_id = evt2.event_id (+)