APPS.BSC_APPS dependencies on V$PARAMETER

Line 22: | used alias for view "v$parameter" |

18: | History: Created By: Mauricio Eastmond Date: 04-JAN-00
19: |
20: | Srini Jandyala 27-Feb-02 Added Get_Lookup_Value() procedure for HTML UI
21: | 27-03-2003 Adeulgao fixed bug#2865694
22: | used alias for view "v$parameter" |
23: | 20-Aug-03 Adeulgao fixed bug#3008243 added 2 functions |
24: | (overloaded) get_user_schema to get the schema name |
25: | 22-Aug-03 Adeulgao modified the query to fetch oracle schema name|
26: | 27-Aug-03 Aditya Removed Hardcoded literals. |

Line 1028: v$parameter VP

1024: CURSOR c_utl_file_dir IS
1025: SELECT
1026: VP.value
1027: FROM
1028: v$parameter VP
1029: WHERE
1030: UPPER(VP.name) = 'UTL_FILE_DIR';
1031:
1032: h_utl_file_dir VARCHAR2(2000);