APPS.HR_EX_EMPLOYEE_API dependencies on PER_PERFORMANCE_REVIEWS

Line 130: from per_performance_reviews ppr

126: select 'X'
127: into v_dummy
128: from sys.dual
129: where exists ( select 'Perf Review rows exist'
130: from per_performance_reviews ppr
131: where ppr.person_id = p_person_id
132: and review_date > p_session_date
133: );
134: p_status := 'WARNING';

Line 873: FROM per_events pe, per_performance_reviews pr

869: PROCEDURE delete_perf(p_person_id IN NUMBER,p_term_date date) IS
870:
871: cursor csr_perfs(p_person_id NUMBER, p_term_date1 DATE) is
872: select pe.event_id,pe.object_version_number pe_ovn, pr.performance_review_id, pr.object_version_number
873: FROM per_events pe, per_performance_reviews pr
874: WHERE pr.person_id = p_person_id
875: AND pr.event_id = pe.event_id
876: AND pr.review_date > p_term_date1
877: ORDER BY performance_review_id,event_id;