APPS.OTA_LEARNER_ENROLL_REVIEW_SS dependencies on OTA_CATEGORY_USAGES_TL

Line 1015: l_delivery_mode ota_category_usages_tl.category%type;

1011: l_event_title ota_events.title%type;
1012: l_course_start_date ota_events.course_start_date%type;
1013: l_course_start_time ota_events.course_start_time%type;
1014: l_course_end_date ota_events.course_end_date%type;
1015: l_delivery_mode ota_category_usages_tl.category%type;
1016: l_event_location hr_locations_all.location_code%TYPE;
1017:
1018: l_notification_text VARCHAR2(1000);
1019: l_business_group_name PER_BUSINESS_GROUPS.name%TYPE := null;

Line 1068: -- (Select Category from ota_category_usages_tl where Category_Usage_Id = ofr.Delivery_Mode_Id

1064: evt.business_group_id bg_id,
1065: evt.course_start_time,
1066: Ctl.Category,
1067: -- Modified for bug 3389890 as usage of inline query in CURSOR is not supported in 8.1.7
1068: -- (Select Category from ota_category_usages_tl where Category_Usage_Id = ofr.Delivery_Mode_Id
1069: -- and Language = userenv('LANG')) Delivery_Mode,
1070: ota_general.get_location_code(ota_utility.get_event_location(evt.event_id)) Location_Name,
1071: ota_timezone_util.get_timezone_name(evt.timezone) timezone,
1072: evt.course_end_time

Line 1075: OTA_CATEGORY_USAGES_TL ctl,

1071: ota_timezone_util.get_timezone_name(evt.timezone) timezone,
1072: evt.course_end_time
1073: FROM OTA_EVENTS_VL evt,
1074: OTA_OFFERINGS ofr,
1075: OTA_CATEGORY_USAGES_TL ctl,
1076: HR_ALL_ORGANIZATION_UNITS hao
1077: WHERE evt.event_id = l_eventid
1078: AND evt.parent_offering_id = ofr.offering_id
1079: AND evt.organization_id = hao.organization_id (+)

Line 2190: from ota_offerings ofe, ota_category_usages_tl ocu

2186:
2187:
2188: cursor get_lang_det is
2189: select ofe.language_id, ocu.category
2190: from ota_offerings ofe, ota_category_usages_tl ocu
2191: where ofe.delivery_mode_id = ocu.category_usage_id
2192: and ocu.language=USERENV('LANG')
2193: and ofe.offering_id = l_off_id;
2194: