APPS.BSC_SIMULATION_VIEW_PVT dependencies on V$NLS_PARAMETERS

Line 32: l_number_format v$nls_parameters.value%TYPE;

28: p_format_Id IN VARCHAR2
29: ) RETURN VARCHAR2 IS
30:
31: l_attribute7 AK_REGION_ITEMS_VL.attribute7%TYPE;
32: l_number_format v$nls_parameters.value%TYPE;
33: l_replace_format VARCHAR2(10);
34: l_Sql VARCHAR2(32000);
35: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
36: l_id NUMBER;

Line 61: FROM v$nls_parameters

57: ' WHERE format_id ='||p_format_Id;
58:
59: SELECT value
60: INTO l_number_format
61: FROM v$nls_parameters
62: WHERE parameter = 'NLS_NUMERIC_CHARACTERS';
63:
64: IF(l_number_format IS NOT NULL) THEN
65: l_decimal_separator := SUBSTR(TRIM(l_number_format),0,1);

Line 1349: l_number_format v$nls_parameters.value%TYPE;

1345: ) IS
1346: l_region_code AK_REGIONS.region_code%TYPE;
1347: l_attribute_code AK_REGION_ITEMS_VL.attribute_code%TYPE;
1348: l_meas_short_name BIS_INDICATORS.short_name%TYPE;
1349: l_number_format v$nls_parameters.value%TYPE;
1350: l_replace_format VARCHAR2(10);
1351: l_attribute7 AK_REGION_ITEMS_VL.attribute7%TYPE;
1352:
1353: CURSOR c_ind IS