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 1370: from ota_category_usages_tl ocu , ota_offerings oaf

1366:
1367:
1368: Cursor get_DM is
1369: select ocu.category
1370: from ota_category_usages_tl ocu , ota_offerings oaf
1371: where oaf.delivery_mode_id = ocu.category_usage_id
1372: and oaf.offering_id = p_offering_id
1373: and ocu.Language = USERENV('LANG');
1374:

Line 1957: FROM ota_offerings

1953: l_offering_count number;
1954:
1955: CURSOR c_get_offering_count IS
1956: SELECT count(*)
1957: FROM ota_offerings
1958: WHERE learning_object_id = p_learning_object_id;
1959:
1960: BEGIN
1961: open c_get_offering_count;

Line 1995: FROM ota_offerings

1991: l_offering_count number;
1992:
1993: CURSOR c_get_course_offering_count IS
1994: SELECT count(*)
1995: FROM ota_offerings
1996: WHERE activity_version_id = p_activity_version_id;
1997:
1998: BEGIN
1999: open c_get_course_offering_count;