1097: CURSOR c_posted_rating(v_person_id IN NUMBER,
1098: v_effective_date IN DATE)
1099: IS
1100: select perf.performance_rating
1101: from per_performance_reviews perf
1102: where perf.person_id = v_person_id
1103: and perf.review_date = v_effective_date;
1104:
1105: CURSOR c_posted_promotions(v_assignment_id IN NUMBER,