APPS.OTA_CPE_UTIL dependencies on OTA_OFFERINGS

Line 2153: ota_offerings ofr,

2149: select csu.online_flag,
2150: csu.synchronous_flag,
2151: ofr.offering_id
2152: from ota_category_usages csu,
2153: ota_offerings ofr,
2154: ota_events evt
2155: where evt.event_id = p_event_id
2156: and evt.parent_offering_id = ofr.offering_id
2157: and ofr.delivery_mode_id = csu.category_usage_id;

Line 2162: ota_offerings ofr

2158:
2159: cursor csr_act_id(csr_offering_id number) is
2160: select act.activity_version_id
2161: from ota_activity_versions act,
2162: ota_offerings ofr
2163: where ofr.offering_id = csr_offering_id
2164: and ofr.activity_version_id = act.activity_version_id;
2165:
2166: CURSOR csr_chk_prds(l_activity_version_id number) IS