APPS.OKL_LEASE_APP_PVT dependencies on OKL_SYSTEM_PARAMS

Line 66: FROM OKL_SYSTEM_PARAMS;

62: l_ou_tax_upfront_yn VARCHAR2(1);
63:
64: CURSOR l_systemparams_csr IS
65: SELECT NVL(tax_upfront_yn,'N')
66: FROM OKL_SYSTEM_PARAMS;
67:
68: BEGIN
69: OPEN l_systemparams_csr;
70: FETCH l_systemparams_csr INTO l_ou_tax_upfront_yn;

Line 589: FROM okl_system_params;

585: TYPE l_csr_typ IS REF CURSOR;
586: l_ref_csr l_csr_typ;
587: CURSOR c_get_prefix(c_table_name IN VARCHAR2) IS
588: 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)
589: FROM okl_system_params;
590: l_prefix VARCHAR2(30);
591: l_value VARCHAR(250);
592: BEGIN
593: l_next_val := 0;