APPS.FUN_XML_REPORT_PKG dependencies on V$NLS_PARAMETERS

Line 138: and lookup_code = ( select value from v$nls_parameters where parameter='NLS_CHARACTERSET')

134: l_invoice_count := 0;
135: l_trx_count := 0;
136: select tag INTO l_encoding from fnd_lookup_values
137: where lookup_type = 'FND_ISO_CHARACTER_SET_MAP'
138: and lookup_code = ( select value from v$nls_parameters where parameter='NLS_CHARACTERSET')
139: and language='US' ;
140:
141: put_starttag('?xml version="1.0" encoding="'||l_encoding||'"?');
142: put_starttag('NETTING_REPORT');

Line 492: and lookup_code = ( select value from v$nls_parameters where parameter='NLS_CHARACTERSET')

488: l_trx_count := 0;
489:
490: select tag INTO l_encoding from fnd_lookup_values
491: where lookup_type = 'FND_ISO_CHARACTER_SET_MAP'
492: and lookup_code = ( select value from v$nls_parameters where parameter='NLS_CHARACTERSET')
493: and language='US' ;
494:
495: put_starttag('?xml version="1.0" encoding="'||l_encoding||'"?');
496: put_starttag('NETTING_REPORT');