APPS.HR_WPM_MASS_APR_PUSH dependencies on HR_LOOKUPS

Line 112: structure_type hr_lookups.meaning%TYPE,

108: position_id per_competence_elements.position_id%TYPE,
109: valid_grade_id per_competence_elements.valid_grade_id%TYPE,
110: business_group_id per_competence_elements.business_group_id%TYPE,
111: enterprise_id per_competence_elements.enterprise_id%TYPE,
112: structure_type hr_lookups.meaning%TYPE,
113: read_only_attr number,
114: detail_attr number,
115: competence_alias per_competences.competence_alias%TYPE,
116: global varchar2(1),

Line 125: lookup_code hr_lookups.lookup_code%TYPE,

121: low_step_value per_rating_levels_vl.step_value%TYPE,
122: low_step_name per_rating_levels_vl.name%TYPE,
123: high_step_value per_rating_levels_vl.step_value%TYPE,
124: high_step_name per_rating_levels_vl.name%TYPE,
125: lookup_code hr_lookups.lookup_code%TYPE,
126: minimum_proficiency varchar2(100),
127: maximum_proficiency varchar2(100),
128: type per_competence_elements.type%TYPE);
129:

Line 572: hr_lookups hrl,

568: decode(r2.step_value, null, null, r2.step_value||' - '||r2.name) maximum_proficiency,
569: pce.type
570: FROM per_competence_elements pce,
571: per_competences_vl pc,
572: hr_lookups hrl,
573: per_rating_levels_vl r1,
574: per_rating_levels_vl r2
575: WHERE pce.type = 'REQUIREMENT'
576: AND pce.competence_id = pc.competence_id