APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on HR_LOOKUPS

Line 154: structure_type hr_lookups.meaning%TYPE,

150: position_id per_competence_elements.position_id%TYPE,
151: valid_grade_id per_competence_elements.valid_grade_id%TYPE,
152: business_group_id per_competence_elements.business_group_id%TYPE,
153: enterprise_id per_competence_elements.enterprise_id%TYPE,
154: structure_type hr_lookups.meaning%TYPE,
155: read_only_attr number,
156: detail_attr number,
157: competence_alias per_competences.competence_alias%TYPE,
158: global varchar2(1),

Line 167: lookup_code hr_lookups.lookup_code%TYPE,

163: low_step_value per_rating_levels_vl.step_value%TYPE,
164: low_step_name per_rating_levels_vl.name%TYPE,
165: high_step_value per_rating_levels_vl.step_value%TYPE,
166: high_step_name per_rating_levels_vl.name%TYPE,
167: lookup_code hr_lookups.lookup_code%TYPE,
168: minimum_proficiency varchar2(100),
169: maximum_proficiency varchar2(100),
170: type per_competence_elements.type%TYPE);
171:

Line 2005: hr_lookups hrl,

2001: decode(r2.step_value, null, null, r2.step_value||' - '||r2.name) maximum_proficiency,
2002: pce.type
2003: FROM per_competence_elements pce,
2004: per_competences_vl pc,
2005: hr_lookups hrl,
2006: per_rating_levels_vl r1,
2007: per_rating_levels_vl r2
2008: WHERE pce.type = 'REQUIREMENT'
2009: AND pce.competence_id = pc.competence_id

Line 5494: IF hr_api.not_exists_in_hr_lookups(p_effective_date => p_effective_date

5490: hr_api.mandatory_arg_error(p_api_name => 'PLAN_ADMIN_ACTIONS_CP'
5491: ,p_argument => 'P_TASK_CODE'
5492: ,p_argument_value => p_task_code);
5493: END IF;
5494: IF hr_api.not_exists_in_hr_lookups(p_effective_date => p_effective_date
5495: ,p_lookup_type => 'HR_WPM_ADMIN_ACTIONS'
5496: ,p_lookup_code => p_task_code) THEN
5497: log_message('Invalid task code selected.'||p_task_code);
5498: hr_utility.set_message(800,'HR_WPM_TASK_CODE_NOT_EXISTS');

Line 6471: IF hr_api.not_exists_in_hr_lookups(p_effective_date => l_effective_date

6467: ,p_argument => 'P_TASK_CODE'
6468: ,p_argument_value => p_task_code);
6469: END IF;
6470: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
6471: IF hr_api.not_exists_in_hr_lookups(p_effective_date => l_effective_date
6472: ,p_lookup_type => 'HR_WPM_ADMIN_ACTIONS'
6473: ,p_lookup_code => p_task_code) THEN
6474: log_message('Invalid task code selected.'||p_task_code);
6475: hr_utility.set_message(800,'HR_WPM_TASK_CODE_NOT_EXISTS');