APPS.PN_EXP_TO_AR dependencies on GL_SETS_OF_BOOKS

Line 84: FROM gl_sets_of_books

80: WHERE salesrep_required_flag = 'Y';
81:
82: CURSOR get_func_curr_code(p_set_of_books_id IN NUMBER) IS
83: SELECT currency_code
84: FROM gl_sets_of_books
85: WHERE set_of_books_id = p_set_of_books_id;
86:
87: CURSOR get_send_flag(p_lease_id NUMBER) IS
88: SELECT nvl(send_entries,'Y')

Line 117: l_func_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;

113: g_grp_by_purpose_flag BOOLEAN := FALSE;
114: g_grp_by_type_flag BOOLEAN := FALSE;
115: g_grp_by_lenum_flag BOOLEAN := FALSE;
116:
117: l_func_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;
118: Q_Billitem_grp VARCHAR2(30000);
119: Q_Billitem_nogrp VARCHAR2(30000);
120: l_ord_clause VARCHAR(1000) :=
121: ' order by

Line 612: l_func_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;

608: l_total_rev_percent NUMBER := 0;
609: l_diff_amt NUMBER := 0;
610: l_set_of_books_id NUMBER := to_number(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
611: pn_mo_cache_utils.get_current_org_id));
612: l_func_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;
613: exp_ar_tbl exp_ar_tbl_type;
614: l_total_items NUMBER := 0;
615: l_index NUMBER := 1;
616: l_start NUMBER;

Line 1910: l_func_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;

1906: l_total_rev_percent NUMBER := 0;
1907: l_diff_amt NUMBER := 0;
1908: l_set_of_books_id NUMBER := to_number(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1909: pn_mo_cache_utils.get_current_org_id));
1910: l_func_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;
1911: l_conv_rate_type PN_CURRENCIES.conversion_type%TYPE;
1912: l_conv_rate PN_PAYMENT_ITEMS.rate%TYPE;
1913: v_location_id PN_LOCATIONS.location_id%TYPE;
1914: l_send_flag PN_LEASE_DETAILS_ALL.send_entries%TYPE := 'Y';