DBA Data[Home] [Help]

APPS.OTA_TPL_BUS dependencies on OTA_BOOKING_DEALS

Line 354: from ota_booking_deals

350: return boolean is
351: ----------------------------
352: cursor csr_child is
353: select 1
354: from ota_booking_deals
355: where price_list_id = p_tpl_id;
356:
357: l_child_exists boolean;
358:

Line 510: from ota_booking_deals

506: --*** Start_dates are mandatory in price lists and booking deals
507: ----------------
508: cursor csr_tbd_min_startdate is
509: select min(start_date)
510: from ota_booking_deals
511: where price_list_id = p_tpl_id;
512:
513: mindate date;
514:

Line 608: from ota_booking_deals

604: --*** end dates may be null
605: -------------------
606: cursor csr_tbd_max_enddate is
607: select max(nvl(end_date,g_end_of_time))
608: from ota_booking_deals
609: where price_list_id = p_tpl_id;
610: --
611: maxdate date;
612: --