DBA Data[Home] [Help]

APPS.OKL_LA_PAYMENTS_PVT dependencies on V$PARAMETER

Line 1695: FROM v$parameter

1691: Cursor get_dir is
1692: SELECT nvl(substrb(translate(ltrim(value),',',' '),
1693: 1,
1694: instr(translate(ltrim(value),',',' '),' ') - 1),value)
1695: FROM v$parameter
1696: WHERE name = 'utl_file_dir';
1697:
1698: l_TEMP_DIR varchar2(200);
1699: delimit varchar2(10) := ' ';

Line 1965: FROM v$parameter

1961: Cursor get_dir is
1962: SELECT nvl(substrb(translate(ltrim(value),',',' '),
1963: 1,
1964: instr(translate(ltrim(value),',',' '),' ') - 1),value)
1965: FROM v$parameter
1966: WHERE name = 'utl_file_dir';
1967:
1968: l_TEMP_DIR varchar2(200);
1969: delimit varchar2(10) := ' ';