DBA Data[Home] [Help]

APPS.OKL_SPLIT_CONTRACT_PVT dependencies on V$PARAMETER

Line 4504: FROM v$parameter

4500:
4501: CURSOR get_dir IS
4502: SELECT NVL(SUBSTRB(TRANSLATE(LTRIM(value),',',' '), 1,
4503: INSTR(TRANSLATE(LTRIM(value),',',' '),' ') - 1),value)
4504: FROM v$parameter
4505: WHERE name = 'utl_file_dir';
4506:
4507: CURSOR c_get_sts_code(p_khr_id OKC_K_HEADERS_B.ID%TYPE) IS
4508: SELECT sts_code