DBA Data[Home] [Help]

APPS.BEN_CWB_BACKOUT_POST_PROCESS dependencies on PER_PERFORMANCE_REVIEWS

Line 665: from per_performance_reviews perf

661: CURSOR c_posted_rating(v_person_id IN NUMBER,
662: v_effective_date IN DATE)
663: IS
664: select perf.performance_rating
665: from per_performance_reviews perf
666: where perf.person_id = v_person_id
667: and perf.review_date = v_effective_date;
668:
669: CURSOR c_slaves(v_request_id IN NUMBER)

Line 2786: from per_performance_reviews perf

2782: cursor c_performance_id_in_db is
2783: select perf.performance_review_id
2784: ,perf.event_id
2785: ,perf.object_version_number
2786: from per_performance_reviews perf
2787: where perf.person_id = p_person_id
2788: and perf.review_date = l_perf_date;
2789: --
2790: cursor c_perf_id_attached_event_type is