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_DATA_MODEL_UPGRADE dependencies on PER_PERFORMANCE_REVIEWS

Line 1113: from per_performance_reviews rtg1

1109: ,(select rtg1.review_date review_date
1110: ,rtg1.performance_rating performance_rating
1111: ,rtg1.person_id person_id
1112: ,apr.appraisal_id
1113: from per_performance_reviews rtg1
1114: ,per_events evt1
1115: ,per_appraisals apr
1116: where rtg1.event_id = evt1.event_id (+)
1117: and rtg1.review_date < p_lf_evt_ocrd_dt

Line 1152: from per_performance_reviews rtg2

1148: and ppf.person_id = perf.person_id (+)
1149: and nvl(perf.review_date, to_date('4712/12/31', 'yyyy/mm/dd')) =
1150: (select nvl(max(rtg2.review_date),to_date('4712/12/31',
1151: 'yyyy/mm/dd'))
1152: from per_performance_reviews rtg2
1153: ,per_events evt2
1154: where rtg2.person_id = ppf.person_id
1155: and rtg2.review_date < p_lf_evt_ocrd_dt
1156: and rtg2.event_id = evt2.event_id (+)