400: --
401:
402: CURSOR c_rating IS
403: SELECT ppr.performance_rating
404: FROM per_performance_reviews ppr
405: WHERE ppr.performance_review_id = (SELECT MAX(ppr1.performance_review_id)
406: FROM per_performance_reviews ppr1
407: WHERE ppr1.person_id = p_person_id
408: AND ppr1.review_date <= p_effective_date);
402: CURSOR c_rating IS
403: SELECT ppr.performance_rating
404: FROM per_performance_reviews ppr
405: WHERE ppr.performance_review_id = (SELECT MAX(ppr1.performance_review_id)
406: FROM per_performance_reviews ppr1
407: WHERE ppr1.person_id = p_person_id
408: AND ppr1.review_date <= p_effective_date);
409:
410: l_ret_val per_performance_reviews.performance_rating%type;
406: FROM per_performance_reviews ppr1
407: WHERE ppr1.person_id = p_person_id
408: AND ppr1.review_date <= p_effective_date);
409:
410: l_ret_val per_performance_reviews.performance_rating%type;
411: --
412: BEGIN
413: --
414: OPEN c_rating;