[Home] [Help]
160: competence_id per_competence_elements.competence_id%TYPE,
161: competence_element_id per_competence_elements.competence_element_id%TYPE,
162: TYPE per_competence_elements.TYPE%TYPE,
163: parent_competence_element_id per_competence_elements.parent_competence_element_id%TYPE,
164: NAME per_competences_vl.NAME%TYPE,
165: RANK NUMBER
166: );
167:
168: TYPE bus_rules_comps IS RECORD (
165: RANK NUMBER
166: );
167:
168: TYPE bus_rules_comps IS RECORD (
169: NAME per_competences_vl.NAME%TYPE,
170: competence_id per_competences.competence_id%TYPE,
171: competence_element_id per_competence_elements.competence_element_id%TYPE,
172: mandatory per_competence_elements.mandatory%TYPE,
173: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,
2750: r2.NAME high_step_name, hrl.lookup_code,
2751: DECODE (r1.step_value, NULL, NULL, r1.step_value || ' - ' || r1.NAME) minimum_proficiency,
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'
3015: CURSOR get_assess_templ_comps (p_assess_type_id per_competence_elements.assessment_type_id%TYPE)
3016: IS
3017: SELECT ce.competence_id, ce.competence_element_id, ce.TYPE, ce.parent_competence_element_id, c.NAME,
3018: RANK () OVER (PARTITION BY ce.competence_id ORDER BY ce.competence_element_id) RANK
3019: FROM per_competence_elements a, per_competence_elements ce, per_competences_vl c
3020: WHERE a.assessment_type_id = p_assess_type_id
3021: AND a.TYPE = 'ASSESSMENT_GROUP'
3022: AND (NVL (c.date_from, TRUNC (SYSDATE)) <= TRUNC (SYSDATE))
3023: AND NVL (c.date_to, TRUNC (SYSDATE)) >= TRUNC (SYSDATE)