APPS.OTA_TAV_API_BUSINESS_RULES dependencies on OTA_OFFERINGS

Line 917: from ota_offerings off -- bug 3534657

913: --
914: cursor sel_check_dates is
915: select start_date
916: , end_date
917: from ota_offerings off -- bug 3534657
918: where off.activity_version_id = p_activity_version_id;
919: --
920: Begin
921: --

Line 1109: -- ota_offerings exist.

1105: -- PUBLIC
1106: -- Description:
1107: -- Delete Validation.
1108: -- This activity version may not be deleted if child rows in
1109: -- ota_offerings exist.
1110: --
1111: Procedure check_if_off_exists
1112: (
1113: p_activity_version_id in number

Line 1121: from ota_offerings off

1117: v_proc varchar2(72) := g_package||'check_if_off_exists';
1118: --
1119: cursor sel_off_exists is
1120: select 'Y'
1121: from ota_offerings off
1122: where off.activity_version_id = p_activity_version_id;
1123: --
1124: Begin
1125: --

Line 2135: select 1 from ota_offerings off,ota_category_usages cat

2131: ota_activity_versions
2132: where activity_version_id <> p_activity_version_id;
2133:
2134: cursor cur_offerings is
2135: select 1 from ota_offerings off,ota_category_usages cat
2136: where cat.type ='DM'
2137: and (cat.online_flag = 'Y' or( cat.online_flag = 'N' and cat.synchronous_flag = 'N'))
2138: and cat.category_usage_id = off.delivery_mode_id
2139: and off.activity_version_id = p_activity_version_id;

Line 2142: select 1 from ota_offerings off,

2138: and cat.category_usage_id = off.delivery_mode_id
2139: and off.activity_version_id = p_activity_version_id;
2140:
2141: cursor csr_enr is -- For bug 4401602
2142: select 1 from ota_offerings off,
2143: ota_events evt,
2144: ota_delegate_bookings tdb
2145: where evt.parent_offering_id = off.offering_id
2146: and tdb.event_id = evt.event_id