DBA Data[Home] [Help]

APPS.HR_MEE_VIEWS_GEN dependencies on PER_PERFORMANCE_REVIEWS

Line 799: FROM per_performance_reviews pr

795: l_perf_id Number := -1;
796:
797: CURSOR c_performance_reviews IS
798: SELECT nvl(max(performance_review_id),-1)
799: FROM per_performance_reviews pr
800: WHERE pr.person_id = p_person_id
801: AND pr.review_date = (SELECT max(review_date)
802: FROM per_performance_reviews ipr, fnd_sessions fs
803: WHERE fs.session_id = userenv('sessionid')

Line 802: FROM per_performance_reviews ipr, fnd_sessions fs

798: SELECT nvl(max(performance_review_id),-1)
799: FROM per_performance_reviews pr
800: WHERE pr.person_id = p_person_id
801: AND pr.review_date = (SELECT max(review_date)
802: FROM per_performance_reviews ipr, fnd_sessions fs
803: WHERE fs.session_id = userenv('sessionid')
804: AND ipr.person_id = pr.person_id
805: AND ipr.review_date <= fs.effective_date);
806: