APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on HR_LOOKUPS

Line 181: structure_type hr_lookups.meaning%TYPE,

177: position_id per_competence_elements.position_id%TYPE,
178: valid_grade_id per_competence_elements.valid_grade_id%TYPE,
179: business_group_id per_competence_elements.business_group_id%TYPE,
180: enterprise_id per_competence_elements.enterprise_id%TYPE,
181: structure_type hr_lookups.meaning%TYPE,
182: read_only_attr NUMBER,
183: detail_attr NUMBER,
184: competence_alias per_competences.competence_alias%TYPE,
185: GLOBAL VARCHAR2 (1),

Line 194: lookup_code hr_lookups.lookup_code%TYPE,

190: low_step_value per_rating_levels_vl.step_value%TYPE,
191: low_step_name per_rating_levels_vl.NAME%TYPE,
192: high_step_value per_rating_levels_vl.step_value%TYPE,
193: high_step_name per_rating_levels_vl.NAME%TYPE,
194: lookup_code hr_lookups.lookup_code%TYPE,
195: minimum_proficiency VARCHAR2 (100),
196: maximum_proficiency VARCHAR2 (100),
197: TYPE per_competence_elements.TYPE%TYPE
198: );

Line 2755: hr_lookups hrl,

2751: DECODE (r1.step_value, NULL, NULL, r1.step_value || ' - ' || r1.NAME) minimum_proficiency,
2752: DECODE (r2.step_value, NULL, NULL, r2.step_value || ' - ' || r2.NAME) maximum_proficiency, pce.TYPE
2753: FROM per_competence_elements pce,
2754: per_competences_vl pc,
2755: hr_lookups hrl,
2756: per_rating_levels_vl r1,
2757: per_rating_levels_vl r2
2758: WHERE pce.TYPE = 'REQUIREMENT'
2759: AND pce.competence_id = pc.competence_id

Line 9150: IF hr_api.not_exists_in_hr_lookups (p_effective_date => p_effective_date,

9146: p_argument_value => p_sub_taskcode
9147: );
9148: END IF;
9149:
9150: IF hr_api.not_exists_in_hr_lookups (p_effective_date => p_effective_date,
9151: p_lookup_type => 'PER_PMP_TRNF_ACTIONS',
9152: p_lookup_code => p_sub_taskcode
9153: )
9154: THEN

Line 9268: IF hr_api.not_exists_in_hr_lookups (p_effective_date => l_effective_date,

9264: END IF;
9265: log_message('l_task_code:'||l_task_code);
9266: log_message('l_sub_taskcode:'||l_sub_taskcode);
9267:
9268: IF hr_api.not_exists_in_hr_lookups (p_effective_date => l_effective_date,
9269: p_lookup_type => 'HR_WPM_ADMIN_ACTIONS',
9270: p_lookup_code => l_task_code
9271: )
9272: THEN

Line 11017: IF hr_api.not_exists_in_hr_lookups (p_effective_date => l_effective_date,

11013: --
11014: --
11015: FOR i IN 1 .. l_task_cnt
11016: LOOP --
11017: IF hr_api.not_exists_in_hr_lookups (p_effective_date => l_effective_date,
11018: p_lookup_type => 'HR_WPM_PUBLISH_TASKS',
11019: p_lookup_code => t_task_codes (i)
11020: )
11021: THEN