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 1204: -- ota_booking_deals exist.

1200: -- PUBLIC
1201: -- Description:
1202: -- Delete Validation.
1203: -- This activity version may not be deleted if child rows in
1204: -- ota_booking_deals exist.
1205: --
1206: Procedure check_if_tbd_exists
1207: (
1208: p_activity_version_id in number

Line 1216: from ota_booking_deals tbd

1212: v_proc varchar2(72) := g_package||'check_if_tbd_exists';
1213: --
1214: cursor sel_tbd_exists is
1215: select 'Y'
1216: from ota_booking_deals tbd
1217: where tbd.activity_version_id = p_activity_version_id;
1218: --
1219: Begin
1220: --