APPS.OTA_ADMIN_ACCESS_UTIL dependencies on OTA_OFFERINGS

Line 50: From ota_offerings

46: where event_id=p_object_id;
47:
48: Cursor get_course_id_for_offering is
49: Select activity_version_id
50: From ota_offerings
51: where offering_id=p_object_id;
52:
53: l_act_ver_id number:=null;
54: l_category_id number:=null;

Line 827: FROM ota_offerings

823: l_offering_count number;
824:
825: CURSOR c_get_offering_count IS
826: SELECT count(*)
827: FROM ota_offerings
828: WHERE learning_object_id = p_learning_object_id
829: and admin_can_access_object('O',offering_id)='Y';
830:
831: BEGIN