APPS.OTA_UTILITY dependencies on OTA_OFFERINGS

Line 163: --, ota_offerings off

159:
160: cursor value_course_level is
161: select oav.competency_update_level from
162: ota_activity_versions oav
163: --, ota_offerings off
164: where oav.activity_version_id = p_obj_id;
165: --and off.offering_id = p_obj_id;
166:
167: begin

Line 1434: from ota_category_usages_tl ocu , ota_offerings oaf

1430:
1431:
1432: Cursor get_DM is
1433: select ocu.category
1434: from ota_category_usages_tl ocu , ota_offerings oaf
1435: where oaf.delivery_mode_id = ocu.category_usage_id
1436: and oaf.offering_id = p_offering_id
1437: and ocu.Language = USERENV('LANG');
1438:

Line 2021: FROM ota_offerings

2017: l_offering_count number;
2018:
2019: CURSOR c_get_offering_count IS
2020: SELECT count(*)
2021: FROM ota_offerings
2022: WHERE learning_object_id = p_learning_object_id;
2023:
2024: BEGIN
2025: open c_get_offering_count;

Line 2059: FROM ota_offerings

2055: l_offering_count number;
2056:
2057: CURSOR c_get_course_offering_count IS
2058: SELECT count(*)
2059: FROM ota_offerings
2060: WHERE activity_version_id = p_activity_version_id;
2061:
2062: BEGIN
2063: open c_get_course_offering_count;