APPS.HR_APPRAISALS_UTIL_SS dependencies on PER_RATING_LEVELS_VL

Line 8: from per_competence_elements pce, per_rating_levels_vl prl1, per_rating_levels_vl prl2,

4: -- Global cursor for getting competence ratings
5: CURSOR get_competence_ratings(p_competence_id NUMBER,
6: p_assessment_id NUMBER) IS
7: select prl1.step_value prof_value, prl2.step_value perf_value, prl3.step_value weigh_value
8: from per_competence_elements pce, per_rating_levels_vl prl1, per_rating_levels_vl prl2,
9: per_rating_levels_vl prl3
10: where pce.assessment_id = p_assessment_id and pce.competence_id = p_competence_id
11: and pce.type='ASSESSMENT' and pce.object_name='ASSESSOR_ID'
12: and pce.proficiency_level_id = prl1.rating_level_id(+)

Line 9: per_rating_levels_vl prl3

5: CURSOR get_competence_ratings(p_competence_id NUMBER,
6: p_assessment_id NUMBER) IS
7: select prl1.step_value prof_value, prl2.step_value perf_value, prl3.step_value weigh_value
8: from per_competence_elements pce, per_rating_levels_vl prl1, per_rating_levels_vl prl2,
9: per_rating_levels_vl prl3
10: where pce.assessment_id = p_assessment_id and pce.competence_id = p_competence_id
11: and pce.type='ASSESSMENT' and pce.object_name='ASSESSOR_ID'
12: and pce.proficiency_level_id = prl1.rating_level_id(+)
13: and pce.rating_level_id = prl2.rating_level_id (+)

Line 24: from per_performance_ratings ppr, per_rating_levels_vl prl, per_assessments pas,

20: -- Global cursor for getting objective ratings
21: CURSOR get_objective_ratings(p_objective_id NUMBER,
22: p_assessment_id NUMBER) IS
23: select prl.step_value perf_value, pos.weighting_percent weigh_percent
24: from per_performance_ratings ppr, per_rating_levels_vl prl, per_assessments pas,
25: per_objectives pos
26: where pas.assessment_id = p_assessment_id
27: and ppr.objective_id = p_objective_id
28: and ppr.appraisal_id = pas.appraisal_id