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 616: l_func_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;

612: l_total_rev_percent NUMBER := 0;
613: l_diff_amt NUMBER := 0;
614: l_set_of_books_id NUMBER := to_number(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
615: pn_mo_cache_utils.get_current_org_id));
616: l_func_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;
617: exp_ar_tbl exp_ar_tbl_type;
618: err_ar_tbl err_ar_tbl_type;-- Bug 14762515
619: l_total_items NUMBER := 0;
620: l_index NUMBER := 1;

Line 1956: l_func_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;

1952: l_total_rev_percent NUMBER := 0;
1953: l_diff_amt NUMBER := 0;
1954: l_set_of_books_id NUMBER := to_number(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1955: pn_mo_cache_utils.get_current_org_id));
1956: l_func_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;
1957: l_conv_rate_type PN_CURRENCIES.conversion_type%TYPE;
1958: l_conv_rate PN_PAYMENT_ITEMS.rate%TYPE;
1959: v_location_id PN_LOCATIONS.location_id%TYPE;
1960: l_send_flag PN_LEASE_DETAILS_ALL.send_entries%TYPE := 'Y';