APPS.HRI_BPL_PROFICIENCY dependencies on PER_COMPETENCE_ELEMENTS

Line 24: FROM PER_COMPETENCE_ELEMENTS pce,

20: --
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'

Line 39: PER_COMPETENCE_ELEMENTS cpn

35: AND (apr.appraisee_person_id, apr.appraisal_period_end_date) IN
36: (SELECT prv.appraisee_person_id, MAX(prv.appraisal_period_end_date)
37: FROM PER_APPRAISALS prv,
38: PER_APPRAISALS cur,
39: PER_COMPETENCE_ELEMENTS cpn
40: WHERE prv.appraisee_person_id = p_person_id
41: AND prv.appraisal_period_end_date < cur.appraisal_period_start_date
42: AND cur.appraisal_id = p_appraisal_id
43: AND cpn.object_name = 'APPRAISAL_ID'

Line 49: from PER_COMPETENCE_ELEMENTS

45: GROUP BY prv.appraisee_person_id
46: )
47: AND (ASSESSMENT_ID, PCE.COMPETENCE_ID) IN
48: (select assessment_id, competence_id
49: from PER_COMPETENCE_ELEMENTS
50: where competence_id = p_competence_id
51: AND type = 'ASSESSMENT'
52: AND object_name = 'APPRAISAL_ID'
53: AND object_id = apr.appraisal_id

Line 56: FROM PER_COMPETENCE_ELEMENTS

52: AND object_name = 'APPRAISAL_ID'
53: AND object_id = apr.appraisal_id
54: INTERSECT
55: SELECT assessment_id, COMPETENCE_ID
56: FROM PER_COMPETENCE_ELEMENTS
57: WHERE competence_id = p_competence_id
58: AND type = 'ASSESSMENT'
59: AND object_name = 'ASSESSOR_ID'
60: AND object_id = p_main_appraiser_id);

Line 113: FROM PER_COMPETENCE_ELEMENTS pce,

109: --
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'

Line 124: FROM PER_COMPETENCE_ELEMENTS

120: AND rtl.rating_level_id = rtx.rating_level_id (+)
121: AND rtx.language(+) = userenv('LANG')
122: AND (pce.assessment_id, pce.competence_id) IN
123: (SELECT assessment_id, competence_id
124: FROM PER_COMPETENCE_ELEMENTS
125: WHERE competence_id = p_competence_id
126: AND type = 'ASSESSMENT'
127: AND object_name = 'APPRAISAL_ID'
128: AND object_id = p_appraisal_id

Line 131: FROM PER_COMPETENCE_ELEMENTS

127: AND object_name = 'APPRAISAL_ID'
128: AND object_id = p_appraisal_id
129: INTERSECT
130: SELECT assessment_id, competence_id
131: FROM PER_COMPETENCE_ELEMENTS
132: WHERE competence_id = p_competence_id
133: AND type = 'ASSESSMENT'
134: AND object_name = 'ASSESSOR_ID'
135: AND object_id = p_main_appraiser_id);

Line 190: FROM PER_COMPETENCE_ELEMENTS pce,

186: IS
187: --
188: Cursor c_flag(p_competence_id IN NUMBER, p_appraisal_id IN NUMBER, p_person_id IN NUMBER) is
189: SELECT 'Y' flag
190: FROM PER_COMPETENCE_ELEMENTS pce,
191: PER_APPRAISALS apr
192: WHERE apr.appraisal_id = p_appraisal_id
193: AND pce.competence_id = p_competence_id
194: AND pce.object_id = p_appraisal_id