[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