APPS.OTA_TFL_API_BUSINESS_RULES3 dependencies on OTA_FINANCE_HEADERS

Line 34: v_finance_customer_id OTA_FINANCE_HEADERS.CUSTOMER_ID%type;

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;
38: v_limit_each_event_flag varchar2(1);

Line 35: v_receivable_type OTA_FINANCE_HEADERS.RECEIVABLE_TYPE%type;

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;
38: v_limit_each_event_flag varchar2(1);
39: --

Line 43: from ota_finance_headers

39: --
40: --
41: cursor csr_tfh is
42: select customer_id,receivable_type
43: from ota_finance_headers
44: where finance_header_id = p_finance_header_id;
45: --
46: --
47: cursor csr_tbd is