eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on PER_RATING_LEVELS_VL

Line 190: low_step_value per_rating_levels_vl.step_value%TYPE,

186: description per_competences.description%TYPE,
187: date_from per_competences.date_from%TYPE,
188: certification_required per_competences.certification_required%TYPE,
189: behavioural_indicator per_competences.behavioural_indicator%TYPE,
190: low_step_value per_rating_levels_vl.step_value%TYPE,
191: low_step_name per_rating_levels_vl.NAME%TYPE,
192: high_step_value per_rating_levels_vl.step_value%TYPE,
193: high_step_name per_rating_levels_vl.NAME%TYPE,
194: lookup_code hr_lookups.lookup_code%TYPE,

Line 191: low_step_name per_rating_levels_vl.NAME%TYPE,

187: date_from per_competences.date_from%TYPE,
188: certification_required per_competences.certification_required%TYPE,
189: behavioural_indicator per_competences.behavioural_indicator%TYPE,
190: low_step_value per_rating_levels_vl.step_value%TYPE,
191: low_step_name per_rating_levels_vl.NAME%TYPE,
192: high_step_value per_rating_levels_vl.step_value%TYPE,
193: high_step_name per_rating_levels_vl.NAME%TYPE,
194: lookup_code hr_lookups.lookup_code%TYPE,
195: minimum_proficiency VARCHAR2 (100),

Line 192: high_step_value per_rating_levels_vl.step_value%TYPE,

188: certification_required per_competences.certification_required%TYPE,
189: behavioural_indicator per_competences.behavioural_indicator%TYPE,
190: low_step_value per_rating_levels_vl.step_value%TYPE,
191: low_step_name per_rating_levels_vl.NAME%TYPE,
192: high_step_value per_rating_levels_vl.step_value%TYPE,
193: high_step_name per_rating_levels_vl.NAME%TYPE,
194: lookup_code hr_lookups.lookup_code%TYPE,
195: minimum_proficiency VARCHAR2 (100),
196: maximum_proficiency VARCHAR2 (100),

Line 193: high_step_name per_rating_levels_vl.NAME%TYPE,

189: behavioural_indicator per_competences.behavioural_indicator%TYPE,
190: low_step_value per_rating_levels_vl.step_value%TYPE,
191: low_step_name per_rating_levels_vl.NAME%TYPE,
192: high_step_value per_rating_levels_vl.step_value%TYPE,
193: high_step_name per_rating_levels_vl.NAME%TYPE,
194: lookup_code hr_lookups.lookup_code%TYPE,
195: minimum_proficiency VARCHAR2 (100),
196: maximum_proficiency VARCHAR2 (100),
197: TYPE per_competence_elements.TYPE%TYPE

Line 2756: per_rating_levels_vl r1,

2752: DECODE (r2.step_value, NULL, NULL, r2.step_value || ' - ' || r2.NAME) maximum_proficiency, pce.TYPE
2753: FROM per_competence_elements pce,
2754: per_competences_vl pc,
2755: hr_lookups hrl,
2756: per_rating_levels_vl r1,
2757: per_rating_levels_vl r2
2758: WHERE pce.TYPE = 'REQUIREMENT'
2759: AND pce.competence_id = pc.competence_id
2760: AND TRUNC (SYSDATE) BETWEEN NVL (pce.effective_date_from, TRUNC (SYSDATE))

Line 2757: per_rating_levels_vl r2

2753: FROM per_competence_elements pce,
2754: per_competences_vl pc,
2755: hr_lookups hrl,
2756: per_rating_levels_vl r1,
2757: per_rating_levels_vl r2
2758: WHERE pce.TYPE = 'REQUIREMENT'
2759: AND pce.competence_id = pc.competence_id
2760: AND TRUNC (SYSDATE) BETWEEN NVL (pce.effective_date_from, TRUNC (SYSDATE))
2761: AND NVL (pce.effective_date_to, TRUNC (SYSDATE))