APPS.FUN_XML_REPORT_PKG dependencies on V$NLS_PARAMETERS

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

145: AND FNB.BATCH_ID = p_batch_id;
146:
147: select tag INTO l_encoding from fnd_lookup_values
148: where lookup_type = 'FND_ISO_CHARACTER_SET_MAP'
149: and lookup_code = ( select value from v$nls_parameters where parameter='NLS_CHARACTERSET')
150: and language='US' ;
151:
152: put_starttag('?xml version="1.0" encoding="'||l_encoding||'"?');
153: put_starttag('NETTING_REPORT');

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

523: AND FNB.BATCH_ID = p_batch_id;
524:
525: select tag INTO l_encoding from fnd_lookup_values
526: where lookup_type = 'FND_ISO_CHARACTER_SET_MAP'
527: and lookup_code = ( select value from v$nls_parameters where parameter='NLS_CHARACTERSET')
528: and language='US' ;
529:
530: put_starttag('?xml version="1.0" encoding="'||l_encoding||'"?');
531: put_starttag('NETTING_REPORT');