[Home] [Help]
134: competence_id per_competence_elements.competence_id%TYPE,
135: competence_element_id per_competence_elements.competence_element_id%TYPE,
136: type per_competence_elements.type%TYPE,
137: parent_competence_element_id per_competence_elements.parent_competence_element_id%TYPE,
138: name per_competences_vl.name%TYPE,
139: rank number );
140:
141: TYPE bus_rules_comps IS RECORD(
142: name per_competences_vl.name%TYPE,
138: name per_competences_vl.name%TYPE,
139: rank number );
140:
141: TYPE bus_rules_comps IS RECORD(
142: name per_competences_vl.name%TYPE,
143: competence_id per_competences.competence_id%TYPE,
144: competence_element_id per_competence_elements.competence_element_id%TYPE,
145: mandatory per_competence_elements.mandatory%TYPE,
146: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,
2000: decode(r1.step_value, null, null, r1.step_value||' - '||r1.name) minimum_proficiency,
2001: decode(r2.step_value, null, null, r2.step_value||' - '||r2.name) maximum_proficiency,
2002: pce.type
2003: FROM per_competence_elements pce,
2004: per_competences_vl pc,
2005: hr_lookups hrl,
2006: per_rating_levels_vl r1,
2007: per_rating_levels_vl r2
2008: WHERE pce.type = 'REQUIREMENT'
2238: cursor get_assess_templ_comps(p_assess_type_id per_competence_elements.assessment_type_id%TYPE)
2239: IS
2240: select ce.competence_id, ce.competence_element_id, ce.type, ce.parent_competence_element_id, c.name,
2241: rank() over (partition by ce.competence_id order by ce.competence_element_id) rank
2242: from per_competence_elements a, per_competence_elements ce, per_competences_vl c
2243: where a.assessment_type_id = p_assess_type_id
2244: and a.type = 'ASSESSMENT_GROUP'
2245: and (nvl(c.date_from,trunc(sysdate)) <= trunc(sysdate))
2246: and nvl(c.date_to,trunc(sysdate)) >= trunc(sysdate)