APPS.PER_APT_BUS dependencies on PER_RATING_SCALES

Line 962: l_type per_rating_scales.type%TYPE;

958:
959: l_exists varchar2(1);
960: l_api_updating boolean;
961: l_proc varchar2(72) := g_package||'chk_rating_scale';
962: l_type per_rating_scales.type%TYPE;
963: l_business_group_id per_appraisal_templates.business_group_id%TYPE;
964: l_overall_performance_level_id per_appraisals.overall_performance_level_id%TYPE;
965:
966:

Line 973: from per_rating_scales

969:
970: Cursor csr_rating_scale_exists
971: is
972: select business_group_id,type
973: from per_rating_scales
974: where rating_scale_id = p_rating_scale_id;
975:
976: -- Cursor to check if the appraisal template
977: -- is used in appraisal and the overall_performance_level_id