APPS.OTA_CPE_UTIL dependencies on OTA_OFFERINGS

Line 2192: ota_offerings ofr,

2188: select csu.online_flag,
2189: csu.synchronous_flag,
2190: ofr.offering_id
2191: from ota_category_usages csu,
2192: ota_offerings ofr,
2193: ota_events evt
2194: where evt.event_id = p_event_id
2195: and evt.parent_offering_id = ofr.offering_id
2196: and ofr.delivery_mode_id = csu.category_usage_id;

Line 2201: ota_offerings ofr

2197:
2198: cursor csr_act_id(csr_offering_id number) is
2199: select act.activity_version_id
2200: from ota_activity_versions act,
2201: ota_offerings ofr
2202: where ofr.offering_id = csr_offering_id
2203: and ofr.activity_version_id = act.activity_version_id;
2204:
2205: CURSOR csr_chk_prds(l_activity_version_id number) IS