APPS.IRC_SKILLS_MATCHING_PKG dependencies on PER_COMPETENCES

Line 11: skill_id PER_COMPETENCES.competence_id%type,

7:
8: --GLOBAL TYPES gt_...
9: --Tie together the corresponding 3 related ID's
10: TYPE gt_skill_rec_type IS RECORD (
11: skill_id PER_COMPETENCES.competence_id%type,
12: max_id PER_RATING_LEVELS.rating_level_id%TYPE,
13: min_id PER_RATING_LEVELS.rating_level_id%TYPE,
14: essential PER_COMPETENCE_ELEMENTS.mandatory%TYPE );
15:

Line 34: FROM per_competences pc,

30: pc.rating_scale_id,
31: MAX(minpr.STEP_VALUE) highest_min_level,
32: MIN(maxpr.STEP_VALUE) lowest_max_level,
33: pce.MANDATORY
34: FROM per_competences pc,
35: per_competence_elements pce,
36: per_rating_levels minpr,
37: per_rating_levels maxpr
38: WHERE pc.competence_id = pce.competence_id

Line 174: skill_id PER_COMPETENCES.competence_id%type,

170: l_rating_level_tab lt_rating_level_tab_type;
171:
172: --Tie together the corresponding 3 related ID's
173: TYPE lr_input_rec_type IS RECORD (
174: skill_id PER_COMPETENCES.competence_id%type,
175: max_level_num PER_RATING_LEVELS.step_value%TYPE,
176: min_level_num PER_RATING_LEVELS.step_value%TYPE );
177:
178: --Type to hold the set of records tying in the sets of three related input strings