eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_TEA_BUS dependencies on OTA_BOOKING_DEALS

Line 348: from ota_booking_deals

344: l_warn boolean := false;
345: --
346: cursor c_overdraft_limit is
347: select nvl(overdraft_limit,0)
348: from ota_booking_deals
349: where booking_deal_id = p_booking_deal_id;
350: --
351: cursor c_amount_so_far is
352: select sum(nvl(money_amount,0))

Line 772: from ota_booking_deals tbd

768: and tpl.price_list_type = 'M')
769: or
770: (p_booking_deal_type is not null
771: and exists (select null
772: from ota_booking_deals tbd
773: where tbd.booking_deal_id = p_booking_deal_id
774: and (tbd.price_list_id is null
775: or (tbd.price_list_id is not null
776: and tbd.price_list_id = tpl.price_list_id