APPS.HR_APPRAISALS_UTIL_SS dependencies on PER_COMPETENCE_ELEMENTS

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 506: from per_competence_elements pce

502: where per_assessments.assessment_id = p_assessment_id
503: and per_assessments.assessment_type_id = per_assessment_types.assessment_type_id;
504: cursor get_competences is
505: select distinct pce.competence_id
506: from per_competence_elements pce
507: where pce.assessment_id = p_assessment_id and pce.type='ASSESSMENT'
508: and pce.object_name = 'ASSESSOR_ID';
509: cursor get_objectives is
510: select po.objective_id

Line 589: FROM per_competence_elements pce

585: FROM dual
586: WHERE EXISTS
587: (
588: SELECT 'Y'
589: FROM per_competence_elements pce
590: WHERE pce.assessment_id = p_assessment_id
591: AND pce.type = 'ASSESSMENT'
592: AND pce.object_name = 'ASSESSOR_ID');
593: l_dummy varchar2(1);