DBA Data[Home] [Help]

APPS.BEN_CWB_DATA_MODEL_UPGRADE dependencies on PER_APPRAISALS

Line 1115: ,per_appraisals apr

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
1118: and nvl(evt1.type, '-X-X-X-') = nvl(l_performance_rating_type, '-X-X-X-')
1119: and evt1.event_id = apr.event_id(+)) perf