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_WPM_MASS_APR_PUSH dependencies on PER_RATING_LEVELS_VL

Line 135: low_step_value per_rating_levels_vl.step_value%TYPE,

131: description per_competences.description%TYPE,
132: date_from per_competences.date_from%TYPE,
133: certification_required per_competences.certification_required%TYPE,
134: behavioural_indicator per_competences.behavioural_indicator%TYPE,
135: low_step_value per_rating_levels_vl.step_value%TYPE,
136: low_step_name per_rating_levels_vl.NAME%TYPE,
137: high_step_value per_rating_levels_vl.step_value%TYPE,
138: high_step_name per_rating_levels_vl.NAME%TYPE,
139: lookup_code hr_lookups.lookup_code%TYPE,

Line 136: low_step_name per_rating_levels_vl.NAME%TYPE,

132: date_from per_competences.date_from%TYPE,
133: certification_required per_competences.certification_required%TYPE,
134: behavioural_indicator per_competences.behavioural_indicator%TYPE,
135: low_step_value per_rating_levels_vl.step_value%TYPE,
136: low_step_name per_rating_levels_vl.NAME%TYPE,
137: high_step_value per_rating_levels_vl.step_value%TYPE,
138: high_step_name per_rating_levels_vl.NAME%TYPE,
139: lookup_code hr_lookups.lookup_code%TYPE,
140: minimum_proficiency VARCHAR2 (100),

Line 137: high_step_value per_rating_levels_vl.step_value%TYPE,

133: certification_required per_competences.certification_required%TYPE,
134: behavioural_indicator per_competences.behavioural_indicator%TYPE,
135: low_step_value per_rating_levels_vl.step_value%TYPE,
136: low_step_name per_rating_levels_vl.NAME%TYPE,
137: high_step_value per_rating_levels_vl.step_value%TYPE,
138: high_step_name per_rating_levels_vl.NAME%TYPE,
139: lookup_code hr_lookups.lookup_code%TYPE,
140: minimum_proficiency VARCHAR2 (100),
141: maximum_proficiency VARCHAR2 (100),

Line 138: high_step_name per_rating_levels_vl.NAME%TYPE,

134: behavioural_indicator per_competences.behavioural_indicator%TYPE,
135: low_step_value per_rating_levels_vl.step_value%TYPE,
136: low_step_name per_rating_levels_vl.NAME%TYPE,
137: high_step_value per_rating_levels_vl.step_value%TYPE,
138: high_step_name per_rating_levels_vl.NAME%TYPE,
139: lookup_code hr_lookups.lookup_code%TYPE,
140: minimum_proficiency VARCHAR2 (100),
141: maximum_proficiency VARCHAR2 (100),
142: TYPE per_competence_elements.TYPE%TYPE

Line 733: per_rating_levels_vl r1,

729: pce.TYPE
730: FROM per_competence_elements pce,
731: per_competences_vl pc,
732: hr_lookups hrl,
733: per_rating_levels_vl r1,
734: per_rating_levels_vl r2
735: WHERE pce.TYPE = 'REQUIREMENT'
736: AND pce.competence_id = pc.competence_id
737: AND TRUNC (SYSDATE) BETWEEN NVL (pce.effective_date_from,

Line 734: per_rating_levels_vl r2

730: FROM per_competence_elements pce,
731: per_competences_vl pc,
732: hr_lookups hrl,
733: per_rating_levels_vl r1,
734: per_rating_levels_vl r2
735: WHERE pce.TYPE = 'REQUIREMENT'
736: AND pce.competence_id = pc.competence_id
737: AND TRUNC (SYSDATE) BETWEEN NVL (pce.effective_date_from,
738: TRUNC (SYSDATE)

Line 784: per_rating_levels_vl r1,

780: pce.TYPE
781: FROM per_competence_elements pce,
782: per_competences_vl pc,
783: hr_lookups hrl,
784: per_rating_levels_vl r1,
785: per_rating_levels_vl r2
786: WHERE pce.TYPE = 'REQUIREMENT'
787: AND pce.competence_id = pc.competence_id
788: AND TRUNC (SYSDATE) BETWEEN NVL (pce.effective_date_from,

Line 785: per_rating_levels_vl r2

781: FROM per_competence_elements pce,
782: per_competences_vl pc,
783: hr_lookups hrl,
784: per_rating_levels_vl r1,
785: per_rating_levels_vl r2
786: WHERE pce.TYPE = 'REQUIREMENT'
787: AND pce.competence_id = pc.competence_id
788: AND TRUNC (SYSDATE) BETWEEN NVL (pce.effective_date_from,
789: TRUNC (SYSDATE)

Line 835: per_rating_levels_vl r1,

831: pce.TYPE
832: FROM per_competence_elements pce,
833: per_competences_vl pc,
834: hr_lookups hrl,
835: per_rating_levels_vl r1,
836: per_rating_levels_vl r2
837: WHERE pce.TYPE = 'REQUIREMENT'
838: AND pce.competence_id = pc.competence_id
839: AND TRUNC (SYSDATE) BETWEEN NVL (pce.effective_date_from,

Line 836: per_rating_levels_vl r2

832: FROM per_competence_elements pce,
833: per_competences_vl pc,
834: hr_lookups hrl,
835: per_rating_levels_vl r1,
836: per_rating_levels_vl r2
837: WHERE pce.TYPE = 'REQUIREMENT'
838: AND pce.competence_id = pc.competence_id
839: AND TRUNC (SYSDATE) BETWEEN NVL (pce.effective_date_from,
840: TRUNC (SYSDATE)

Line 886: per_rating_levels_vl r1,

882: pce.TYPE
883: FROM per_competence_elements pce,
884: per_competences_vl pc,
885: hr_lookups hrl,
886: per_rating_levels_vl r1,
887: per_rating_levels_vl r2
888: WHERE pce.TYPE = 'REQUIREMENT'
889: AND pce.competence_id = pc.competence_id
890: AND TRUNC (SYSDATE) BETWEEN NVL (pce.effective_date_from,

Line 887: per_rating_levels_vl r2

883: FROM per_competence_elements pce,
884: per_competences_vl pc,
885: hr_lookups hrl,
886: per_rating_levels_vl r1,
887: per_rating_levels_vl r2
888: WHERE pce.TYPE = 'REQUIREMENT'
889: AND pce.competence_id = pc.competence_id
890: AND TRUNC (SYSDATE) BETWEEN NVL (pce.effective_date_from,
891: TRUNC (SYSDATE)