APPS.HR_SUIT_MATCH_UTILITY_WEB dependencies on PER_RATING_LEVELS

Line 24: ,low_step_value per_rating_levels.step_value%TYPE

20: ,competence_id per_competences.competence_id%TYPE
21: ,competence_name per_competences.name%TYPE
22: ,low_rating_level_id per_competence_elements.proficiency_level_id%TYPE
23: ,high_rating_level_id per_competence_elements.high_proficiency_level_id%TYPE
24: ,low_step_value per_rating_levels.step_value%TYPE
25: ,low_step_name per_rating_levels.name%TYPE
26: ,high_step_value per_rating_levels.step_value%TYPE
27: ,high_step_name per_rating_levels.name%TYPE
28: ,mandatory per_competence_elements.mandatory%TYPE

Line 25: ,low_step_name per_rating_levels.name%TYPE

21: ,competence_name per_competences.name%TYPE
22: ,low_rating_level_id per_competence_elements.proficiency_level_id%TYPE
23: ,high_rating_level_id per_competence_elements.high_proficiency_level_id%TYPE
24: ,low_step_value per_rating_levels.step_value%TYPE
25: ,low_step_name per_rating_levels.name%TYPE
26: ,high_step_value per_rating_levels.step_value%TYPE
27: ,high_step_name per_rating_levels.name%TYPE
28: ,mandatory per_competence_elements.mandatory%TYPE
29: ,checked varchar(1) );

Line 26: ,high_step_value per_rating_levels.step_value%TYPE

22: ,low_rating_level_id per_competence_elements.proficiency_level_id%TYPE
23: ,high_rating_level_id per_competence_elements.high_proficiency_level_id%TYPE
24: ,low_step_value per_rating_levels.step_value%TYPE
25: ,low_step_name per_rating_levels.name%TYPE
26: ,high_step_value per_rating_levels.step_value%TYPE
27: ,high_step_name per_rating_levels.name%TYPE
28: ,mandatory per_competence_elements.mandatory%TYPE
29: ,checked varchar(1) );
30: TYPE g_competence_table IS TABLE of g_competence_rec

Line 27: ,high_step_name per_rating_levels.name%TYPE

23: ,high_rating_level_id per_competence_elements.high_proficiency_level_id%TYPE
24: ,low_step_value per_rating_levels.step_value%TYPE
25: ,low_step_name per_rating_levels.name%TYPE
26: ,high_step_value per_rating_levels.step_value%TYPE
27: ,high_step_name per_rating_levels.name%TYPE
28: ,mandatory per_competence_elements.mandatory%TYPE
29: ,checked varchar(1) );
30: TYPE g_competence_table IS TABLE of g_competence_rec
31: INDEX BY BINARY_INTEGER;

Line 213: RETURN per_rating_levels.step_value%TYPE;

209: -- get_step_value
210: -- ---------------------------------------------------------------------------
211:
212: FUNCTION get_step_value(p_rating_level_id in number)
213: RETURN per_rating_levels.step_value%TYPE;
214: -- ---------------------------------------------------------------------------
215: -- get_competence_name
216: -- ---------------------------------------------------------------------------
217: