APPS.HR_SUIT_MATCH_UTILITY_WEB dependencies on PER_COMPETENCE_LEVELS_V

Line 104: ||' FROM per_competence_levels_v'

100: l_ids := build_items(p_id => p_competence_id);
101:
102: l_dynamic_sql :=
103: 'SELECT max(count(step_value))'
104: ||' FROM per_competence_levels_v'
105: ||' WHERE competence_id IN ('||l_ids||')'
106: ||' GROUP BY competence_id';
107:
108: l_sql_cursor := dbms_sql.open_cursor;

Line 537: FROM per_competence_levels_v

533: RETURN per_rating_levels.step_value%TYPE IS
534:
535: CURSOR csr_step_value IS
536: SELECT step_value
537: FROM per_competence_levels_v
538: WHERE rating_level_id = p_rating_level_id;
539:
540: l_step_value per_rating_levels.step_value%TYPE;
541: