DBA Data[Home] [Help]

APPS.BEN_CWB_PERSON_INFO_PKG dependencies on PER_EVENTS

Line 671: ,per_events evt1

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
675: and ((p_appraisal_n_days is not null and rtg1.review_date between (p_effective_date - p_appraisal_n_days) and p_effective_date)

Line 721: ,per_events evt2

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
725: and ((p_appraisal_n_days is not null and rtg2.review_date between (p_effective_date - p_appraisal_n_days) and p_effective_date)