[Home] [Help]
66: * 115.33 12-Nov-2010 sgnanama Updated new_perf_event_id and new_perf_review_id
67: * after post process
68: * 115.34 31-Oct-2012 kmsuresh Updated new_perf_event id, new_perf_review_id and
69: * performance_rating when new record created in
70: * per_performance_reviews
71: * ==========================================================================+
72: */
73:
74: g_package varchar2(80) := 'ben_cwb_asg_update.';
2493: cursor c_performance_id_in_db is
2494: select perf.performance_review_id
2495: ,perf.event_id
2496: ,perf.object_version_number
2497: from per_performance_reviews perf
2498: where perf.person_id = p_person_id
2499: and perf.review_date = l_perf_date;
2500: --
2501: cursor c_perf_id_attached_event_type is