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')
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: