DBA Data[Home] [Help]

APPS.HR_MEE_VIEWS_GEN dependencies on PER_PERFORMANCE_REVIEWS

Line 756: FROM per_performance_reviews pr

752: l_perf_id Number := -1;
753:
754: CURSOR c_performance_reviews IS
755: SELECT nvl(max(performance_review_id),-1)
756: FROM per_performance_reviews pr
757: WHERE pr.person_id = p_person_id
758: AND pr.review_date = (SELECT max(review_date)
759: FROM per_performance_reviews ipr, fnd_sessions fs
760: WHERE fs.session_id = userenv('sessionid')

Line 759: FROM per_performance_reviews ipr, fnd_sessions fs

755: SELECT nvl(max(performance_review_id),-1)
756: FROM per_performance_reviews pr
757: WHERE pr.person_id = p_person_id
758: AND pr.review_date = (SELECT max(review_date)
759: FROM per_performance_reviews ipr, fnd_sessions fs
760: WHERE fs.session_id = userenv('sessionid')
761: AND ipr.person_id = pr.person_id
762: AND ipr.review_date <= fs.effective_date);
763: