APPS.OTA_COMPETENCE_SS dependencies on OTA_CATEGORY_USAGES

Line 192: ota_offerings off, ota_category_usages ocu

188:
189: Cursor course_eff_date is
190: select oev.course_end_date
191: from ota_events oev,
192: ota_offerings off, ota_category_usages ocu
193: where oev.event_id=p_id
194: and (oev.parent_offering_id = off.offering_id or oev.offering_id = off.offering_id)
195: and off.delivery_mode_id = ocu.category_usage_id
196: and ocu.synchronous_flag = 'Y';