DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_PVT dependencies on OKL_SYSTEM_PARAMS

Line 143: FROM OKL_SYSTEM_PARAMS;

139: l_err_msg VARCHAR2(80);
140:
141: CURSOR l_systemparams_csr IS
142: SELECT NVL(tax_upfront_yn,'N')
143: FROM OKL_SYSTEM_PARAMS;
144:
145: BEGIN
146: OPEN l_systemparams_csr;
147: FETCH l_systemparams_csr INTO l_ou_tax_upfront_yn;

Line 2464: FROM OKL_SYSTEM_PARAMS;

2460:
2461: -- Bug#9708535 - Added - Start
2462: CURSOR l_systemparams_csr IS
2463: SELECT NVL(tax_upfront_yn,'N')
2464: FROM OKL_SYSTEM_PARAMS;
2465:
2466: -- Check if upfront tax calculation has happened for this quote
2467: CURSOR c_chk_tax_calculation (p_quote_id OKL_LEASE_QUOTES_B.ID%TYPE) IS
2468: SELECT 'X'