APPS.OKL_UTIL dependencies on OKL_SYSTEM_PARAMS

Line 335: FROM okl_system_params;

331: TYPE l_csr_typ IS REF CURSOR;
332: l_ref_csr l_csr_typ;
333: CURSOR c_get_prefix(c_table_name IN VARCHAR2) IS
334: SELECT DECODE(c_table_name,'OKL_LEASE_QUOTES_B',LSEQTE_SEQ_PREFIX_TXT,'OKL_QUICK_QUOTES_B',QCKQTE_SEQ_PREFIX_TXT,'OKL_LEASE_OPPORTUNITIES_B',LSEOPP_SEQ_PREFIX_TXT,'OKL_LEASE_APPLICATIONS_B',LSEAPP_SEQ_PREFIX_TXT)
335: FROM okl_system_params;
336: l_prefix VARCHAR2(30);
337: l_value VARCHAR(250);
338: BEGIN
339: l_next_val := 0;

Line 399: FROM okl_system_params;

395: TYPE l_csr_typ IS REF CURSOR;
396: l_ref_csr l_csr_typ;
397: CURSOR c_get_prefix(c_table_name IN VARCHAR2) IS
398: SELECT DECODE(c_table_name,'OKL_LEASE_QUOTES_B',LSEQTE_SEQ_PREFIX_TXT,'OKL_QUICK_QUOTES_B',QCKQTE_SEQ_PREFIX_TXT,'OKL_LEASE_OPPORTUNITIES_B',LSEOPP_SEQ_PREFIX_TXT,'OKL_LEASE_APPLICATIONS_B',LSEAPP_SEQ_PREFIX_TXT)
399: FROM okl_system_params;
400: l_prefix VARCHAR2(30);
401: BEGIN
402: l_query_stmt := 'SELECT ' ||
403: p_col_name ||