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 163: low_step_value per_rating_levels_vl.step_value%TYPE,

159: description per_competences.description%TYPE,
160: date_from per_competences.date_from%TYPE,
161: certification_required per_competences.certification_required%TYPE,
162: behavioural_indicator per_competences.behavioural_indicator%TYPE,
163: low_step_value per_rating_levels_vl.step_value%TYPE,
164: low_step_name per_rating_levels_vl.name%TYPE,
165: high_step_value per_rating_levels_vl.step_value%TYPE,
166: high_step_name per_rating_levels_vl.name%TYPE,
167: lookup_code hr_lookups.lookup_code%TYPE,

Line 164: low_step_name per_rating_levels_vl.name%TYPE,

160: date_from per_competences.date_from%TYPE,
161: certification_required per_competences.certification_required%TYPE,
162: behavioural_indicator per_competences.behavioural_indicator%TYPE,
163: low_step_value per_rating_levels_vl.step_value%TYPE,
164: low_step_name per_rating_levels_vl.name%TYPE,
165: high_step_value per_rating_levels_vl.step_value%TYPE,
166: high_step_name per_rating_levels_vl.name%TYPE,
167: lookup_code hr_lookups.lookup_code%TYPE,
168: minimum_proficiency varchar2(100),

Line 165: high_step_value per_rating_levels_vl.step_value%TYPE,

161: certification_required per_competences.certification_required%TYPE,
162: behavioural_indicator per_competences.behavioural_indicator%TYPE,
163: low_step_value per_rating_levels_vl.step_value%TYPE,
164: low_step_name per_rating_levels_vl.name%TYPE,
165: high_step_value per_rating_levels_vl.step_value%TYPE,
166: high_step_name per_rating_levels_vl.name%TYPE,
167: lookup_code hr_lookups.lookup_code%TYPE,
168: minimum_proficiency varchar2(100),
169: maximum_proficiency varchar2(100),

Line 166: high_step_name per_rating_levels_vl.name%TYPE,

162: behavioural_indicator per_competences.behavioural_indicator%TYPE,
163: low_step_value per_rating_levels_vl.step_value%TYPE,
164: low_step_name per_rating_levels_vl.name%TYPE,
165: high_step_value per_rating_levels_vl.step_value%TYPE,
166: high_step_name per_rating_levels_vl.name%TYPE,
167: lookup_code hr_lookups.lookup_code%TYPE,
168: minimum_proficiency varchar2(100),
169: maximum_proficiency varchar2(100),
170: type per_competence_elements.type%TYPE);

Line 2006: per_rating_levels_vl r1,

2002: pce.type
2003: FROM per_competence_elements pce,
2004: per_competences_vl pc,
2005: hr_lookups hrl,
2006: per_rating_levels_vl r1,
2007: per_rating_levels_vl r2
2008: WHERE pce.type = 'REQUIREMENT'
2009: AND pce.competence_id = pc.competence_id
2010: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))

Line 2007: per_rating_levels_vl r2

2003: FROM per_competence_elements pce,
2004: per_competences_vl pc,
2005: hr_lookups hrl,
2006: per_rating_levels_vl r1,
2007: per_rating_levels_vl r2
2008: WHERE pce.type = 'REQUIREMENT'
2009: AND pce.competence_id = pc.competence_id
2010: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))
2011: and nvl(pce.effective_date_to, trunc(sysdate))