APPS.OTA_TFL_API_BUSINESS_RULES dependencies on OTA_BOOKING_DEALS

Line 223: v_book_deal_customer_id OTA_BOOKING_DEALS.CUSTOMER_ID%type;

219: ,p_booking_deal_id in number
220: ) is
221: ---------------
222: v_proc varchar2(72) := g_package||'check_booking_deal';
223: v_book_deal_customer_id OTA_BOOKING_DEALS.CUSTOMER_ID%type;
224: v_finance_customer_id OTA_FINANCE_HEADERS.CUSTOMER_ID%type;
225: v_receivable_type OTA_FINANCE_HEADERS.RECEIVABLE_TYPE%type;
226: v_deal_type OTA_BOOKING_DEALS.TYPE%type;
227: v_number_of_places number;

Line 226: v_deal_type OTA_BOOKING_DEALS.TYPE%type;

222: v_proc varchar2(72) := g_package||'check_booking_deal';
223: v_book_deal_customer_id OTA_BOOKING_DEALS.CUSTOMER_ID%type;
224: v_finance_customer_id OTA_FINANCE_HEADERS.CUSTOMER_ID%type;
225: v_receivable_type OTA_FINANCE_HEADERS.RECEIVABLE_TYPE%type;
226: v_deal_type OTA_BOOKING_DEALS.TYPE%type;
227: v_number_of_places number;
228: v_limit_each_event_flag varchar2(1);
229: --
230: cursor csr_tfh is

Line 237: from ota_booking_deals

233: where finance_header_id = p_finance_header_id;
234: --
235: cursor csr_tbd is
236: select customer_id,type,number_of_places,limit_each_event_flag
237: from ota_booking_deals
238: where booking_deal_id = p_booking_deal_id;
239: ---------------
240: Begin
241: --

Line 573: from ota_booking_deals tbd

569: --
570: cursor sel_pricelist_type is
571: select tbd.type
572: , tpl.price_list_type
573: from ota_booking_deals tbd
574: , ota_price_lists tpl
575: where tbd.booking_deal_id = p_booking_deal_id
576: and tpl.price_list_id (+) = tbd.price_list_id;
577: --

Line 1081: from ota_booking_deals tbd

1077: and evt.event_id = tdb.event_id;
1078: --
1079: cursor sel_price_list_currency is
1080: select tpl.currency_code
1081: from ota_booking_deals tbd
1082: , ota_price_lists tpl
1083: where tbd.booking_deal_id = p_booking_deal_id
1084: and tpl.price_list_id = tbd.price_list_id;
1085: --

Line 1248: from ota_booking_deals tbd

1244: and evt.event_id = tdb.event_id;
1245: --
1246: cursor sel_price_list_currency is
1247: select tpl.currency_code
1248: from ota_booking_deals tbd
1249: , ota_price_lists tpl
1250: where tbd.booking_deal_id = p_booking_deal_id
1251: and tpl.price_list_id = tbd.price_list_id;
1252: --