DBA Data[Home] [Help]

APPS.BEN_CWB_DATA_MODEL_UPGRADE dependencies on PER_EVENTS

Line 1114: ,per_events evt1

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

Line 1153: ,per_events evt2

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 (+)
1157: and nvl(evt2.type, '-X-X-X-') = nvl(l_performance_rating_type, '-X-X-X-') )