APPS.HR_SUIT_MATCH_UTILITY_WEB dependencies on PER_COMPETENCES

Line 20: ,competence_id per_competences.competence_id%TYPE

16:
17: TYPE g_competence_rec IS RECORD(
18: competence_element_id per_competence_elements.competence_element_id%TYPE
19: ,effective_date_from per_competence_elements.effective_date_from%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

Line 21: ,competence_name per_competences.name%TYPE

17: TYPE g_competence_rec IS RECORD(
18: competence_element_id per_competence_elements.competence_element_id%TYPE
19: ,effective_date_from per_competence_elements.effective_date_from%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

Line 219: RETURN per_competences_tl.name%type;

215: -- get_competence_name
216: -- ---------------------------------------------------------------------------
217:
218: FUNCTION get_competence_name(p_competence_id in number)
219: RETURN per_competences_tl.name%type;
220:
221: -- ---------------------------------------------------------------------------
222: -- get_drived_org_job
223: -- ---------------------------------------------------------------------------