[Home] [Help]
92: competence_id per_competence_elements.competence_id%TYPE,
93: competence_element_id per_competence_elements.competence_element_id%TYPE,
94: type per_competence_elements.type%TYPE,
95: parent_competence_element_id per_competence_elements.parent_competence_element_id%TYPE,
96: name per_competences_vl.name%TYPE,
97: rank number );
98:
99: TYPE bus_rules_comps IS RECORD(
100: name per_competences_vl.name%TYPE,
96: name per_competences_vl.name%TYPE,
97: rank number );
98:
99: TYPE bus_rules_comps IS RECORD(
100: name per_competences_vl.name%TYPE,
101: competence_id per_competences.competence_id%TYPE,
102: competence_element_id per_competence_elements.competence_element_id%TYPE,
103: mandatory per_competence_elements.mandatory%TYPE,
104: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,
567: decode(r1.step_value, null, null, r1.step_value||' - '||r1.name) minimum_proficiency,
568: decode(r2.step_value, null, null, r2.step_value||' - '||r2.name) maximum_proficiency,
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'
843: cursor get_assess_templ_comps(p_assess_type_id per_competence_elements.assessment_type_id%TYPE)
844: IS
845: select ce.competence_id, ce.competence_element_id, ce.type, ce.parent_competence_element_id, c.name,
846: rank() over (partition by ce.competence_id order by ce.competence_element_id) rank
847: from per_competence_elements a, per_competence_elements ce, per_competences_vl c
848: where a.assessment_type_id = p_assess_type_id
849: and a.type = 'ASSESSMENT_GROUP'
850: and (nvl(c.date_from,trunc(sysdate)) <= trunc(sysdate))
851: and nvl(c.date_to,trunc(sysdate)) >= trunc(sysdate)