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*/ /*Bug8486880*/
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*/ /*Bug8486880*/
49:
50: l_cus_open_bal NUMBER ;

Line 158: FROM gl_sets_of_books sob,ar_system_parameters ar

154: */
155:
156: SELECT sob.name
157: INTO l_organization_name
158: FROM gl_sets_of_books sob,ar_system_parameters ar
159: WHERE sob.set_of_books_id = ar.set_of_books_id;
160:
161: SELECT currency_code
162: INTO l_functional_currency_code

Line 163: FROM gl_sets_of_books sob,ar_system_parameters ar

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