APPS.AR_GET_CUSTOMER_BALANCE_PKG dependencies on GL_SETS_OF_BOOKS

Line 45: l_organization_name gl_sets_of_books.name%TYPE;

41: ,p_ref_no varchar
42: ,p_debug_flag in varchar
43: ,p_trace_flag in varchar
44: ) is
45: l_organization_name gl_sets_of_books.name%TYPE;
46: l_functional_currency_code gl_sets_of_books.currency_code%TYPE;
47: l_session_language varchar2(40);/* For MLS changes */
48: l_base_language varchar2(40); /*For MLS changes*/
49:

Line 46: l_functional_currency_code gl_sets_of_books.currency_code%TYPE;

42: ,p_debug_flag in varchar
43: ,p_trace_flag in varchar
44: ) is
45: l_organization_name gl_sets_of_books.name%TYPE;
46: l_functional_currency_code gl_sets_of_books.currency_code%TYPE;
47: l_session_language varchar2(40);/* For MLS changes */
48: l_base_language varchar2(40); /*For MLS changes*/
49:
50: l_cus_open_bal NUMBER ;

Line 157: FROM gl_sets_of_books sob,ar_system_parameters ar

153: WHERE installed_flag='B';
154:
155: SELECT sob.name
156: INTO l_organization_name
157: FROM gl_sets_of_books sob,ar_system_parameters ar
158: WHERE sob.set_of_books_id = ar.set_of_books_id;
159:
160: SELECT currency_code
161: INTO l_functional_currency_code

Line 162: FROM gl_sets_of_books sob,ar_system_parameters ar

158: WHERE sob.set_of_books_id = ar.set_of_books_id;
159:
160: SELECT currency_code
161: INTO l_functional_currency_code
162: FROM gl_sets_of_books sob,ar_system_parameters ar
163: WHERE sob.set_of_books_id = ar.set_of_books_id;
164:
165: -- customer
166: FOR cusinfo_rec IN cusinfo