DBA Data[Home] [Help]

APPS.BEN_CWB_PERSON_INFO_PKG dependencies on PER_PERFORMANCE_REVIEWS

Line 670: from per_performance_reviews rtg1

666: ,(select rtg1.review_date review_date
667: ,rtg1.performance_rating performance_rating
668: ,rtg1.person_id person_id
669: ,evt1.event_id
670: from per_performance_reviews rtg1
671: ,per_events evt1
672: where rtg1.event_id = evt1.event_id (+)
673: --and rtg1.review_date <= p_effective_date
674: --ER:8369634

Line 720: from per_performance_reviews rtg2

716: and ppf.person_id = perf.person_id (+)
717: and nvl(perf.review_date, to_date('4712/12/31', 'yyyy/mm/dd')) =
718: (select nvl(max(rtg2.review_date),to_date('4712/12/31',
719: 'yyyy/mm/dd'))
720: from per_performance_reviews rtg2
721: ,per_events evt2
722: where rtg2.person_id = ppf.person_id
723: -- and rtg2.review_date <= p_effective_date
724: --ER:8369634