APPS.OTA_CME_UTIL dependencies on OTA_OFFERINGS

Line 223: ota_offerings ofr,

219: CURSOR evt_det IS
220: SELECT evt.activity_version_id,
221: ocu.online_flag
222: FROM ota_events evt,
223: ota_offerings ofr,
224: ota_category_usages ocu
225: WHERE evt.event_id = p_event_id
226: AND evt.parent_offering_id = ofr.offering_id
227: AND OFR.DELIVERY_MODE_ID = ocu.CATEGORY_USAGE_ID;

Line 785: ota_offerings ofr,

781: ota_cert_enrollments cre,
782: ota_cert_prd_enrollments cpe,
783: ota_cert_mbr_enrollments cme,
784: ota_certification_members cmb,
785: ota_offerings ofr,
786: ota_category_usages c
787: WHERE e.event_id = b.event_id
788: AND cre.cert_enrollment_id = cpe.cert_enrollment_id
789: AND cpe.cert_prd_enrollment_id = cme.cert_prd_enrollment_id