DBA Data[Home] [Help]

APPS.OKL_LA_PAYMENTS_PVT dependencies on V$PARAMETER

Line 1902: FROM v$parameter

1898: Cursor get_dir is
1899: SELECT nvl(substrb(translate(ltrim(value),',',' '),
1900: 1,
1901: instr(translate(ltrim(value),',',' '),' ') - 1),value)
1902: FROM v$parameter
1903: WHERE name = 'utl_file_dir';
1904:
1905: l_TEMP_DIR varchar2(200);
1906: delimit varchar2(10) := ' ';

Line 2176: FROM v$parameter

2172: Cursor get_dir is
2173: SELECT nvl(substrb(translate(ltrim(value),',',' '),
2174: 1,
2175: instr(translate(ltrim(value),',',' '),' ') - 1),value)
2176: FROM v$parameter
2177: WHERE name = 'utl_file_dir';
2178:
2179: l_TEMP_DIR varchar2(200);
2180: delimit varchar2(10) := ' ';