APPS.OTA_CME_UTIL dependencies on OTA_OFFERINGS

Line 318: ota_offerings ofr,

314: CURSOR evt_det IS
315: SELECT evt.activity_version_id,
316: ocu.online_flag
317: FROM ota_events evt,
318: ota_offerings ofr,
319: ota_category_usages ocu
320: WHERE evt.event_id = p_event_id
321: AND evt.parent_offering_id = ofr.offering_id
322: AND OFR.DELIVERY_MODE_ID = ocu.CATEGORY_USAGE_ID;

Line 897: ota_offerings ofr,

893: ota_cert_enrollments cre,
894: ota_cert_prd_enrollments cpe,
895: ota_cert_mbr_enrollments cme,
896: ota_certification_members cmb,
897: ota_offerings ofr,
898: ota_category_usages c
899: WHERE e.event_id = b.event_id
900: AND cre.cert_enrollment_id = cpe.cert_enrollment_id
901: AND cpe.cert_prd_enrollment_id = cme.cert_prd_enrollment_id