[Home] [Help]
122: position_id per_competence_elements.position_id%TYPE,
123: valid_grade_id per_competence_elements.valid_grade_id%TYPE,
124: business_group_id per_competence_elements.business_group_id%TYPE,
125: enterprise_id per_competence_elements.enterprise_id%TYPE,
126: structure_type hr_lookups.meaning%TYPE,
127: read_only_attr NUMBER,
128: detail_attr NUMBER,
129: competence_alias per_competences.competence_alias%TYPE,
130: GLOBAL VARCHAR2 (1),
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
143: );
728: ) maximum_proficiency,
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
779: ) maximum_proficiency,
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
830: ) maximum_proficiency,
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
881: ) maximum_proficiency,
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