APPS.HRI_BPL_PROFICIENCY dependencies on PER_RATING_LEVELS

Line 25: PER_RATING_LEVELS rtl ,

21: cursor c_old_lvl (p_competence_id IN NUMBER, p_person_id IN NUMBER
22: , p_appraisal_id IN NUMBER, p_main_appraiser_id IN NUMBER) is
23: SELECT decode(pce.proficiency_level_id,'','',rtl.step_value||'-'||rtx.name) Old_Level
24: FROM PER_COMPETENCE_ELEMENTS pce,
25: PER_RATING_LEVELS rtl ,
26: PER_RATING_LEVELS_TL rtx,
27: PER_APPRAISALS apr
28: WHERE pce.type = 'ASSESSMENT'
29: and pce.object_name = 'ASSESSOR_ID'

Line 26: PER_RATING_LEVELS_TL rtx,

22: , p_appraisal_id IN NUMBER, p_main_appraiser_id IN NUMBER) is
23: SELECT decode(pce.proficiency_level_id,'','',rtl.step_value||'-'||rtx.name) Old_Level
24: FROM PER_COMPETENCE_ELEMENTS pce,
25: PER_RATING_LEVELS rtl ,
26: PER_RATING_LEVELS_TL rtx,
27: PER_APPRAISALS apr
28: WHERE pce.type = 'ASSESSMENT'
29: and pce.object_name = 'ASSESSOR_ID'
30: and object_id = p_main_appraiser_id

Line 114: PER_RATING_LEVELS rtl ,

110: cursor c_new_lvl (p_competence_id IN NUMBER, p_main_appraiser_id IN NUMBER
111: , p_appraisal_id IN NUMBER) is
112: SELECT decode(pce.proficiency_level_id,'','',rtl.step_value||'-'||rtx.name) New_Level
113: FROM PER_COMPETENCE_ELEMENTS pce,
114: PER_RATING_LEVELS rtl ,
115: PER_RATING_LEVELS_TL rtx
116: WHERE pce.type = 'ASSESSMENT'
117: AND object_name = 'ASSESSOR_ID'
118: AND pce.competence_id = p_competence_id

Line 115: PER_RATING_LEVELS_TL rtx

111: , p_appraisal_id IN NUMBER) is
112: SELECT decode(pce.proficiency_level_id,'','',rtl.step_value||'-'||rtx.name) New_Level
113: FROM PER_COMPETENCE_ELEMENTS pce,
114: PER_RATING_LEVELS rtl ,
115: PER_RATING_LEVELS_TL rtx
116: WHERE pce.type = 'ASSESSMENT'
117: AND object_name = 'ASSESSOR_ID'
118: AND pce.competence_id = p_competence_id
119: AND pce.proficiency_level_id = rtl.rating_level_id (+)