APPS.OTA_TAV_API_BUSINESS_RULES dependencies on OTA_OFFERINGS

Line 921: from ota_offerings off -- bug 3534657

917: --
918: cursor sel_check_dates is
919: select start_date
920: , end_date
921: from ota_offerings off -- bug 3534657
922: where off.activity_version_id = p_activity_version_id;
923: --
924: Begin
925: --

Line 1115: -- ota_offerings exist.

1111: -- PUBLIC
1112: -- Description:
1113: -- Delete Validation.
1114: -- This activity version may not be deleted if child rows in
1115: -- ota_offerings exist.
1116: --
1117: Procedure check_if_off_exists
1118: (
1119: p_activity_version_id in number

Line 1127: from ota_offerings off

1123: v_proc varchar2(72) := g_package||'check_if_off_exists';
1124: --
1125: cursor sel_off_exists is
1126: select 'Y'
1127: from ota_offerings off
1128: where off.activity_version_id = p_activity_version_id;
1129: --
1130: Begin
1131: --

Line 2141: select 1 from ota_offerings off,ota_category_usages cat

2137: ota_activity_versions
2138: where activity_version_id <> p_activity_version_id;
2139:
2140: cursor cur_offerings is
2141: select 1 from ota_offerings off,ota_category_usages cat
2142: where cat.type ='DM'
2143: and (cat.online_flag = 'Y' or( cat.online_flag = 'N' and cat.synchronous_flag = 'N'))
2144: and cat.category_usage_id = off.delivery_mode_id
2145: and off.activity_version_id = p_activity_version_id;

Line 2148: select 1 from ota_offerings off,

2144: and cat.category_usage_id = off.delivery_mode_id
2145: and off.activity_version_id = p_activity_version_id;
2146:
2147: cursor csr_enr is -- For bug 4401602
2148: select 1 from ota_offerings off,
2149: ota_events evt,
2150: ota_delegate_bookings tdb
2151: where evt.parent_offering_id = off.offering_id
2152: and tdb.event_id = evt.event_id