919: -- - Validates that the rating scale cannot be updated if overall_rating_id
920: -- is set
921: -- - Validates that the rating scale cannot be updated if the
922: -- appraisal template is used in an Appraisal which in turn is used in
923: -- performace ratings table (per_performance_ratings).
924:
925: -- Pre_conditions:
926:
927: -- In Arguments:
990: Cursor csr_rating_scale_update2
991: is
992: select 'Y'
993: from per_appraisals apr
994: ,per_performance_ratings prt
995: where prt.appraisal_id = apr.appraisal_id
996: and apr.appraisal_template_id = p_appraisal_template_id;
997:
998: