1243: --
1244: -- cursor to check that the rating_level_id is valid
1245: --
1246: cursor csr_val_prof_id
1247: (c_level_id per_rating_levels.rating_level_id%TYPE) is
1248: select business_group_id
1249: from per_rating_levels
1250: where c_level_id = rating_level_id;
1251:
1245: --
1246: cursor csr_val_prof_id
1247: (c_level_id per_rating_levels.rating_level_id%TYPE) is
1248: select business_group_id
1249: from per_rating_levels
1250: where c_level_id = rating_level_id;
1251:
1252: --
1253: -- cursor to check that the parent_comp_element_id is valid
2234: -- This is when the parent of the proficiency is the competence.
2235: --
2236: -- ngundura changes for pa requirements
2237:
2238: from per_rating_levels
2239: where p_competence_id = competence_id
2240: and p_prof_id = rating_level_id
2241: -- where p_business_group_id = business_group_id + 0
2242: -- and p_competence_id = competence_id
2247: -- This is when the parent of the proficiency level is the rating scale.
2248: --
2249:
2250: select ral.step_value
2251: from per_rating_levels ral,
2252: per_rating_scales ras,
2253: per_competences comp
2254: where p_competence_id = comp.competence_id
2255: and ras.rating_scale_id = comp.rating_scale_id
2487: c_scale_type in varchar2)is
2488: select ast.rating_scale_id, ast.weighting_scale_id
2489: from per_assessment_types ast,
2490: per_assessments ass,
2491: per_rating_levels ral
2492: where ass.assessment_id = p_assessment_id
2493: and ass.assessment_type_id = ast.assessment_type_id
2494: and decode(c_scale_type, 'PERFORMANCE', ast.rating_scale_id,
2495: ast.weighting_scale_id) = ral.rating_scale_id
3089: -- ngundura changes done for pa requirements
3090: -- commented the business_group_id check
3091: cursor csr_get_rating_scale_id(c_ass_type_id in number) is
3092: select ast.rating_scale_id, ast.weighting_scale_id
3093: from per_rating_levels ral,
3094: per_assessment_types ast,
3095:
3096: per_rating_scales ras
3097: where ast.assessment_type_id = c_ass_type_id