DBA Data[Home] [Help]

APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on PER_COMPETENCES

Line 164: NAME per_competences_vl.NAME%TYPE,

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 (

Line 169: NAME per_competences_vl.NAME%TYPE,

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,

Line 170: competence_id per_competences.competence_id%TYPE,

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,
174: high_proficiency_level_id per_competence_elements.high_proficiency_level_id%TYPE,

Line 184: competence_alias per_competences.competence_alias%TYPE,

180: enterprise_id per_competence_elements.enterprise_id%TYPE,
181: structure_type hr_lookups.meaning%TYPE,
182: read_only_attr NUMBER,
183: detail_attr NUMBER,
184: competence_alias per_competences.competence_alias%TYPE,
185: GLOBAL VARCHAR2 (1),
186: description per_competences.description%TYPE,
187: date_from per_competences.date_from%TYPE,
188: certification_required per_competences.certification_required%TYPE,

Line 186: description per_competences.description%TYPE,

182: read_only_attr NUMBER,
183: detail_attr NUMBER,
184: competence_alias per_competences.competence_alias%TYPE,
185: GLOBAL VARCHAR2 (1),
186: description per_competences.description%TYPE,
187: date_from per_competences.date_from%TYPE,
188: certification_required per_competences.certification_required%TYPE,
189: behavioural_indicator per_competences.behavioural_indicator%TYPE,
190: low_step_value per_rating_levels_vl.step_value%TYPE,

Line 187: date_from per_competences.date_from%TYPE,

183: detail_attr NUMBER,
184: competence_alias per_competences.competence_alias%TYPE,
185: GLOBAL VARCHAR2 (1),
186: description per_competences.description%TYPE,
187: date_from per_competences.date_from%TYPE,
188: certification_required per_competences.certification_required%TYPE,
189: behavioural_indicator per_competences.behavioural_indicator%TYPE,
190: low_step_value per_rating_levels_vl.step_value%TYPE,
191: low_step_name per_rating_levels_vl.NAME%TYPE,

Line 188: certification_required per_competences.certification_required%TYPE,

184: competence_alias per_competences.competence_alias%TYPE,
185: GLOBAL VARCHAR2 (1),
186: description per_competences.description%TYPE,
187: date_from per_competences.date_from%TYPE,
188: certification_required per_competences.certification_required%TYPE,
189: behavioural_indicator per_competences.behavioural_indicator%TYPE,
190: low_step_value per_rating_levels_vl.step_value%TYPE,
191: low_step_name per_rating_levels_vl.NAME%TYPE,
192: high_step_value per_rating_levels_vl.step_value%TYPE,

Line 189: behavioural_indicator per_competences.behavioural_indicator%TYPE,

185: GLOBAL VARCHAR2 (1),
186: description per_competences.description%TYPE,
187: date_from per_competences.date_from%TYPE,
188: certification_required per_competences.certification_required%TYPE,
189: behavioural_indicator per_competences.behavioural_indicator%TYPE,
190: low_step_value per_rating_levels_vl.step_value%TYPE,
191: low_step_name per_rating_levels_vl.NAME%TYPE,
192: high_step_value per_rating_levels_vl.step_value%TYPE,
193: high_step_name per_rating_levels_vl.NAME%TYPE,

Line 204: competence_id per_competences.competence_id%TYPE

200: TYPE sel_comp_tab IS TABLE OF bus_rules_comps
201: INDEX BY BINARY_INTEGER;
202:
203: TYPE competences_rc IS RECORD (
204: competence_id per_competences.competence_id%TYPE
205: );
206:
207: TYPE competences_tbl IS TABLE OF competences_rc
208: INDEX BY BINARY_INTEGER;

Line 2754: per_competences_vl pc,

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'

Line 3019: FROM per_competence_elements a, per_competence_elements ce, per_competences_vl c

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)