APPS.OTA_TRAINING_RECORD dependencies on PER_COMPETENCE_ELEMENTS

Line 45: competence_id per_competence_elements.competence_id%TYPE,

41: cre_completion_date ota_cert_enrollments.completion_date%TYPE
42: );
43:
44: TYPE cert_comp_rectype IS RECORD(
45: competence_id per_competence_elements.competence_id%TYPE,
46: competence_name per_competences_tl.name%TYPE,
47: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,
48: proficiency_level_name varchar2(100),
49: effective_date_from per_competence_elements.effective_date_from%TYPE,

Line 47: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,

43:
44: TYPE cert_comp_rectype IS RECORD(
45: competence_id per_competence_elements.competence_id%TYPE,
46: competence_name per_competences_tl.name%TYPE,
47: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,
48: proficiency_level_name varchar2(100),
49: effective_date_from per_competence_elements.effective_date_from%TYPE,
50: effective_date_to per_competence_elements.effective_date_to%TYPE,
51: object_id per_competence_elements.object_id%TYPE,

Line 49: effective_date_from per_competence_elements.effective_date_from%TYPE,

45: competence_id per_competence_elements.competence_id%TYPE,
46: competence_name per_competences_tl.name%TYPE,
47: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,
48: proficiency_level_name varchar2(100),
49: effective_date_from per_competence_elements.effective_date_from%TYPE,
50: effective_date_to per_competence_elements.effective_date_to%TYPE,
51: object_id per_competence_elements.object_id%TYPE,
52: business_group_id per_competence_elements.business_group_id%TYPE
53: );

Line 50: effective_date_to per_competence_elements.effective_date_to%TYPE,

46: competence_name per_competences_tl.name%TYPE,
47: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,
48: proficiency_level_name varchar2(100),
49: effective_date_from per_competence_elements.effective_date_from%TYPE,
50: effective_date_to per_competence_elements.effective_date_to%TYPE,
51: object_id per_competence_elements.object_id%TYPE,
52: business_group_id per_competence_elements.business_group_id%TYPE
53: );
54:

Line 51: object_id per_competence_elements.object_id%TYPE,

47: proficiency_level_id per_competence_elements.proficiency_level_id%TYPE,
48: proficiency_level_name varchar2(100),
49: effective_date_from per_competence_elements.effective_date_from%TYPE,
50: effective_date_to per_competence_elements.effective_date_to%TYPE,
51: object_id per_competence_elements.object_id%TYPE,
52: business_group_id per_competence_elements.business_group_id%TYPE
53: );
54:
55: TYPE cert_component_rectype IS RECORD

Line 52: business_group_id per_competence_elements.business_group_id%TYPE

48: proficiency_level_name varchar2(100),
49: effective_date_from per_competence_elements.effective_date_from%TYPE,
50: effective_date_to per_competence_elements.effective_date_to%TYPE,
51: object_id per_competence_elements.object_id%TYPE,
52: business_group_id per_competence_elements.business_group_id%TYPE
53: );
54:
55: TYPE cert_component_rectype IS RECORD
56: (