DBA Data[Home] [Help]

APPS.OTA_TRAINING_RECORD dependencies on HR_LOOKUPS

Line 21: renewable_flag_meaning hr_lookups.meaning%TYPE,

17: notify_days_before_expire ota_certifications_b.notify_days_before_expire%TYPE,
18: validity_duration ota_certifications_b.validity_duration%TYPE,
19: validity_duration_units ota_certifications_b.validity_duration_units%TYPE,
20: renewable_flag_code ota_certifications_b.renewable_flag%TYPE,
21: renewable_flag_meaning hr_lookups.meaning%TYPE,
22: start_date_active ota_certifications_b.start_date_active%TYPE,
23: end_date_active ota_certifications_b.end_date_active%TYPE,
24: name ota_certifications_tl.name%TYPE,
25: description ota_certifications_tl.description%TYPE,

Line 32: cert_status_meaning hr_lookups.meaning%TYPE,

28: keywords ota_certifications_tl.keywords%TYPE,
29: initial_period_comments ota_certifications_tl.initial_period_comments%TYPE,
30: renewal_period_comments ota_certifications_tl.renewal_period_comments%TYPE,
31: certification_status_code ota_cert_enrollments.certification_status_code%TYPE,
32: cert_status_meaning hr_lookups.meaning%TYPE,
33: period_status_code ota_cert_prd_enrollments.period_status_code%TYPE,
34: period_status_meaning hr_lookups.meaning%TYPE,
35: expiration_date ota_cert_enrollments.expiration_date%TYPE,
36: earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%TYPE,

Line 34: period_status_meaning hr_lookups.meaning%TYPE,

30: renewal_period_comments ota_certifications_tl.renewal_period_comments%TYPE,
31: certification_status_code ota_cert_enrollments.certification_status_code%TYPE,
32: cert_status_meaning hr_lookups.meaning%TYPE,
33: period_status_code ota_cert_prd_enrollments.period_status_code%TYPE,
34: period_status_meaning hr_lookups.meaning%TYPE,
35: expiration_date ota_cert_enrollments.expiration_date%TYPE,
36: earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%TYPE,
37: cert_period_start_date ota_cert_prd_enrollments.cert_period_start_date%TYPE,
38: cert_period_end_date ota_cert_prd_enrollments.cert_period_end_date%TYPE,

Line 62: member_status_meaning hr_lookups.meaning%TYPE,

58: activity_version_id ota_activity_versions_vl.activity_version_id%TYPE,
59: member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE,
60: course_name ota_activity_versions_vl.version_name%TYPE,
61: completion_date ota_cert_mbr_enrollments.completion_date%TYPE,
62: member_status_meaning hr_lookups.meaning%TYPE,
63: enrollment_details_icon varchar2(100),
64: version_code ota_activity_versions_vl.version_code%TYPE,
65: activity_version_name ota_activity_versions_vl.version_name%TYPE,
66: start_date ota_activity_versions_vl.start_date%TYPE,

Line 93: period_status_meaning hr_lookups.meaning%TYPE,

89: certification_id ota_cert_enrollments.certification_id%TYPE,
90: certification_status_code ota_cert_enrollments.certification_status_code%TYPE,
91: cert_status_meaning varchar2(240),
92: period_status_code ota_cert_prd_enrollments.period_status_code%TYPE,
93: period_status_meaning hr_lookups.meaning%TYPE,
94: cert_period_start_date ota_cert_prd_enrollments.cert_period_start_date%TYPE,
95: cert_period_end_date ota_cert_prd_enrollments.cert_period_end_date%TYPE,
96: cre_completion_date ota_cert_prd_enrollments.completion_date%TYPE,
97: person_id ota_cert_enrollments.person_id%TYPE,

Line 215: player_status hr_lookups.meaning%TYPE,

211: TYPE booking_rectype IS RECORD
212: (
213: delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE,
214: status ota_booking_status_types_tl.name%TYPE,
215: player_status hr_lookups.meaning%TYPE,
216: booking_id ota_delegate_bookings.booking_id%TYPE,
217: is_history_flag ota_delegate_bookings.is_history_flag%TYPE,
218: date_status_changed ota_delegate_bookings.date_status_changed%TYPE,
219: successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE,

Line 252: success_criteria hr_lookups.meaning%TYPE,

248: tav_information18 ota_activity_versions_vl.tav_information18%TYPE,
249: tav_information19 ota_activity_versions_vl.tav_information19%TYPE,
250: tav_information20 ota_activity_versions_vl.tav_information20%TYPE,
251: activity_version_code ota_activity_versions_vl.version_code%TYPE,
252: success_criteria hr_lookups.meaning%TYPE,
253: professional_credits ota_activity_versions_vl.professional_credits%TYPE,
254: professional_credit_meaning hr_lookups.meaning%TYPE,
255: controlling_person_id ota_activity_versions.controlling_person_id%type,
256: events event_tabletype,

Line 254: professional_credit_meaning hr_lookups.meaning%TYPE,

250: tav_information20 ota_activity_versions_vl.tav_information20%TYPE,
251: activity_version_code ota_activity_versions_vl.version_code%TYPE,
252: success_criteria hr_lookups.meaning%TYPE,
253: professional_credits ota_activity_versions_vl.professional_credits%TYPE,
254: professional_credit_meaning hr_lookups.meaning%TYPE,
255: controlling_person_id ota_activity_versions.controlling_person_id%type,
256: events event_tabletype,
257: booking booking_rectype,
258: event_action VARCHAR2(50)