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.

[Home] [Help]

APPS.HR_WPM_MASS_APR_PUSH dependencies on PER_RATING_LEVELS_VL

Line 121: low_step_value per_rating_levels_vl.step_value%TYPE,

117: description per_competences.description%TYPE,
118: date_from per_competences.date_from%TYPE,
119: certification_required per_competences.certification_required%TYPE,
120: behavioural_indicator per_competences.behavioural_indicator%TYPE,
121: low_step_value per_rating_levels_vl.step_value%TYPE,
122: low_step_name per_rating_levels_vl.name%TYPE,
123: high_step_value per_rating_levels_vl.step_value%TYPE,
124: high_step_name per_rating_levels_vl.name%TYPE,
125: lookup_code hr_lookups.lookup_code%TYPE,

Line 122: low_step_name per_rating_levels_vl.name%TYPE,

118: date_from per_competences.date_from%TYPE,
119: certification_required per_competences.certification_required%TYPE,
120: behavioural_indicator per_competences.behavioural_indicator%TYPE,
121: low_step_value per_rating_levels_vl.step_value%TYPE,
122: low_step_name per_rating_levels_vl.name%TYPE,
123: high_step_value per_rating_levels_vl.step_value%TYPE,
124: high_step_name per_rating_levels_vl.name%TYPE,
125: lookup_code hr_lookups.lookup_code%TYPE,
126: minimum_proficiency varchar2(100),

Line 123: high_step_value per_rating_levels_vl.step_value%TYPE,

119: certification_required per_competences.certification_required%TYPE,
120: behavioural_indicator per_competences.behavioural_indicator%TYPE,
121: low_step_value per_rating_levels_vl.step_value%TYPE,
122: low_step_name per_rating_levels_vl.name%TYPE,
123: high_step_value per_rating_levels_vl.step_value%TYPE,
124: high_step_name per_rating_levels_vl.name%TYPE,
125: lookup_code hr_lookups.lookup_code%TYPE,
126: minimum_proficiency varchar2(100),
127: maximum_proficiency varchar2(100),

Line 124: high_step_name per_rating_levels_vl.name%TYPE,

120: behavioural_indicator per_competences.behavioural_indicator%TYPE,
121: low_step_value per_rating_levels_vl.step_value%TYPE,
122: low_step_name per_rating_levels_vl.name%TYPE,
123: high_step_value per_rating_levels_vl.step_value%TYPE,
124: high_step_name per_rating_levels_vl.name%TYPE,
125: lookup_code hr_lookups.lookup_code%TYPE,
126: minimum_proficiency varchar2(100),
127: maximum_proficiency varchar2(100),
128: type per_competence_elements.type%TYPE);

Line 573: per_rating_levels_vl r1,

569: pce.type
570: FROM per_competence_elements pce,
571: per_competences_vl pc,
572: hr_lookups hrl,
573: per_rating_levels_vl r1,
574: per_rating_levels_vl r2
575: WHERE pce.type = 'REQUIREMENT'
576: AND pce.competence_id = pc.competence_id
577: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))

Line 574: per_rating_levels_vl r2

570: FROM per_competence_elements pce,
571: per_competences_vl pc,
572: hr_lookups hrl,
573: per_rating_levels_vl r1,
574: per_rating_levels_vl r2
575: WHERE pce.type = 'REQUIREMENT'
576: AND pce.competence_id = pc.competence_id
577: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))
578: and nvl(pce.effective_date_to, trunc(sysdate))