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 631: FROM okl_system_params;

627: TYPE l_csr_typ IS REF CURSOR;
628: l_ref_csr l_csr_typ;
629: CURSOR c_get_prefix(c_table_name IN VARCHAR2) IS
630: 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)
631: FROM okl_system_params;
632: l_prefix VARCHAR2(30);
633: l_value VARCHAR(250);
634: BEGIN
635: l_next_val := 0;