APPS.HR_APPRAISALS_API dependencies on PER_PERFORMANCE_REVIEWS

Line 1147: from per_performance_reviews

1143: (select assessment_id from per_assessments where appraisal_id = p_appraisal_id);
1144:
1145: cursor cs_get_perf_review_rec is
1146: select performance_review_id, object_version_number
1147: from per_performance_reviews
1148: where event_id in (select event_id from per_appraisals where appraisal_id = p_appraisal_id);
1149:
1150: --
1151: cursor cs_get_per_events_rec is

Line 1260: (we create an entry in per_performance_reviews table and this has the column

1256: i) delete_participants
1257: j) delete_ota_training_plan_members
1258: - this is under review as to how to be deleted . so nothing for this now
1259: k) hr_perf_review_api.delete_perf_review
1260: (we create an entry in per_performance_reviews table and this has the column
1261: Event_Id which will be same as Event_Id in Per_Appraisals table)
1262: l) per_events_api.delete_event
1263: (we added an Event_id in Per_Appraisals, using that event_id we go here and delete it)
1264: m) delete_appraisal finally .