APPS.OTA_TFL_API_BUSINESS_RULES3 dependencies on OTA_BOOKING_DEALS

Line 33: v_book_deal_customer_id OTA_BOOKING_DEALS.CUSTOMER_ID%type;

29: ,p_booking_deal_id in number
30: ) is
31: ---------------
32: v_proc varchar2(72) := g_package||'check_customer_booking_deal';
33: v_book_deal_customer_id OTA_BOOKING_DEALS.CUSTOMER_ID%type;
34: v_finance_customer_id OTA_FINANCE_HEADERS.CUSTOMER_ID%type;
35: v_receivable_type OTA_FINANCE_HEADERS.RECEIVABLE_TYPE%type;
36: v_deal_type OTA_BOOKING_DEALS.TYPE%type;
37: v_number_of_places number;

Line 36: v_deal_type OTA_BOOKING_DEALS.TYPE%type;

32: v_proc varchar2(72) := g_package||'check_customer_booking_deal';
33: v_book_deal_customer_id OTA_BOOKING_DEALS.CUSTOMER_ID%type;
34: v_finance_customer_id OTA_FINANCE_HEADERS.CUSTOMER_ID%type;
35: v_receivable_type OTA_FINANCE_HEADERS.RECEIVABLE_TYPE%type;
36: v_deal_type OTA_BOOKING_DEALS.TYPE%type;
37: v_number_of_places number;
38: v_limit_each_event_flag varchar2(1);
39: --
40: --

Line 49: from ota_booking_deals

45: --
46: --
47: cursor csr_tbd is
48: select customer_id,type,number_of_places,limit_each_event_flag
49: from ota_booking_deals
50: where booking_deal_id = p_booking_deal_id;
51: ---------------
52: Begin
53: --