APPS.HR_SUIT_MATCH_UTILITY_WEB dependencies on PER_COMPETENCE_ELEMENTS

Line 18: competence_element_id per_competence_elements.competence_element_id%TYPE

14: TYPE g_person_table IS TABLE of g_people_rec
15: INDEX BY BINARY_INTEGER;
16:
17: TYPE g_competence_rec IS RECORD(
18: competence_element_id per_competence_elements.competence_element_id%TYPE
19: ,effective_date_from per_competence_elements.effective_date_from%TYPE
20: ,competence_id per_competences.competence_id%TYPE
21: ,competence_name per_competences.name%TYPE
22: ,low_rating_level_id per_competence_elements.proficiency_level_id%TYPE

Line 19: ,effective_date_from per_competence_elements.effective_date_from%TYPE

15: INDEX BY BINARY_INTEGER;
16:
17: TYPE g_competence_rec IS RECORD(
18: competence_element_id per_competence_elements.competence_element_id%TYPE
19: ,effective_date_from per_competence_elements.effective_date_from%TYPE
20: ,competence_id per_competences.competence_id%TYPE
21: ,competence_name per_competences.name%TYPE
22: ,low_rating_level_id per_competence_elements.proficiency_level_id%TYPE
23: ,high_rating_level_id per_competence_elements.high_proficiency_level_id%TYPE

Line 22: ,low_rating_level_id per_competence_elements.proficiency_level_id%TYPE

18: competence_element_id per_competence_elements.competence_element_id%TYPE
19: ,effective_date_from per_competence_elements.effective_date_from%TYPE
20: ,competence_id per_competences.competence_id%TYPE
21: ,competence_name per_competences.name%TYPE
22: ,low_rating_level_id per_competence_elements.proficiency_level_id%TYPE
23: ,high_rating_level_id per_competence_elements.high_proficiency_level_id%TYPE
24: ,low_step_value per_rating_levels.step_value%TYPE
25: ,low_step_name per_rating_levels.name%TYPE
26: ,high_step_value per_rating_levels.step_value%TYPE

Line 23: ,high_rating_level_id per_competence_elements.high_proficiency_level_id%TYPE

19: ,effective_date_from per_competence_elements.effective_date_from%TYPE
20: ,competence_id per_competences.competence_id%TYPE
21: ,competence_name per_competences.name%TYPE
22: ,low_rating_level_id per_competence_elements.proficiency_level_id%TYPE
23: ,high_rating_level_id per_competence_elements.high_proficiency_level_id%TYPE
24: ,low_step_value per_rating_levels.step_value%TYPE
25: ,low_step_name per_rating_levels.name%TYPE
26: ,high_step_value per_rating_levels.step_value%TYPE
27: ,high_step_name per_rating_levels.name%TYPE

Line 28: ,mandatory per_competence_elements.mandatory%TYPE

24: ,low_step_value per_rating_levels.step_value%TYPE
25: ,low_step_name per_rating_levels.name%TYPE
26: ,high_step_value per_rating_levels.step_value%TYPE
27: ,high_step_name per_rating_levels.name%TYPE
28: ,mandatory per_competence_elements.mandatory%TYPE
29: ,checked varchar(1) );
30: TYPE g_competence_table IS TABLE of g_competence_rec
31: INDEX BY BINARY_INTEGER;
32: