APPS.HRI_BPL_PROFICIENCY dependencies on PER_APPRAISALS

Line 27: PER_APPRAISALS apr

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
31: AND pce.competence_id = p_competence_id

Line 37: FROM PER_APPRAISALS prv,

33: AND rtl.rating_level_id = rtx.rating_level_id (+)
34: AND rtx.language(+) = userenv('LANG')
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

Line 38: PER_APPRAISALS cur,

34: AND rtx.language(+) = userenv('LANG')
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

Line 191: PER_APPRAISALS apr

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
195: AND apr.appraisee_person_id = p_person_id