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