APPS.OTA_TAV_API_BUSINESS_RULES dependencies on OTA_BOOKING_DEALS

Line 851: from ota_booking_deals tbd

847: --
848: cursor sel_check_dates is
849: select start_date
850: , end_date
851: from ota_booking_deals tbd
852: where tbd.activity_version_id = p_activity_version_id;
853: --
854: Begin
855: --

Line 1210: -- ota_booking_deals exist.

1206: -- PUBLIC
1207: -- Description:
1208: -- Delete Validation.
1209: -- This activity version may not be deleted if child rows in
1210: -- ota_booking_deals exist.
1211: --
1212: Procedure check_if_tbd_exists
1213: (
1214: p_activity_version_id in number

Line 1222: from ota_booking_deals tbd

1218: v_proc varchar2(72) := g_package||'check_if_tbd_exists';
1219: --
1220: cursor sel_tbd_exists is
1221: select 'Y'
1222: from ota_booking_deals tbd
1223: where tbd.activity_version_id = p_activity_version_id;
1224: --
1225: Begin
1226: --