DBA Data[Home] [Help]

APPS.AP_GET_SUPPLIER_BALANCE_PKG dependencies on DUAL

Line 153: select substr(userenv('LANG'),1,4) into l_session_language from dual;

149:
150: BEGIN --#1
151:
152: /*Commented the following code fnd added the next two SELECT stmts for bug#1721165 TMANDA
153: select substr(userenv('LANG'),1,4) into l_session_language from dual;
154: select language_code into l_base_language from fnd_languages where installed_flag='B';
155: */
156: -- for bug#1721165 Start TMANDA
157: -- Get the session language

Line 160: from dual;

156: -- for bug#1721165 Start TMANDA
157: -- Get the session language
158: select substr(userenv('LANGUAGE'),1,instr(userenv('LANGUAGE'),'_')-1)
159: into l_session_language
160: from dual;
161:
162: -- Get the base language
163: select nls_language
164: into l_base_language