DBA Data[Home] [Help]

APPS.OKL_SALES_QUOTE_QA_PVT dependencies on OKL_SYSTEM_PARAMS

Line 586: FROM OKL_SYSTEM_PARAMS_ALL;

582: is_debug_procedure_on boolean;
583: is_debug_statement_on boolean;
584: cursor c_sys_opt_vls IS
585: select validation_set_id
586: FROM OKL_SYSTEM_PARAMS_ALL;
587: BEGIN
588: OPEN c_sys_opt_vls;
589: FETCH c_sys_opt_vls INTO l_validation_set_id;
590: CLOSE c_sys_opt_vls;

Line 1276: FROM OKL_SYSTEM_PARAMS;

1272:
1273: --Cursor will get validation Set Id from a Setup table
1274: CURSOR c_sys_opt_vls IS
1275: select validation_set_id
1276: FROM OKL_SYSTEM_PARAMS;
1277: --Cursor will fetch all the Validation for a validation Set
1278: CURSOR c_validation_func(p_vls_id NUMBER) IS
1279: SELECT VLD.failure_severity,FUNCTNS.NAME,FUNCTNS.SOURCE
1280: FROM OKL_VALIDATIONS_B VLD,OKL_DATA_SRC_FNCTNS_B FUNCTNS

Line 2410: FROM OKL_SYSTEM_PARAMS;

2406: --Bug 4713705 SSDESHPA---->Fix End
2407: --Added Bug # 5647107 ssdeshpa start
2408: CURSOR l_systemparams_csr IS
2409: SELECT NVL(tax_upfront_yn,'N')
2410: FROM OKL_SYSTEM_PARAMS;
2411: l_ou_tax_upfront_yn VARCHAR2(1);
2412: l_err_msg VARCHAR2(80);
2413: --Added Bug # 5647107 ssdeshpa end
2414: BEGIN

Line 4749: FROM OKL_SYSTEM_PARAMS;

4745: b_tax_call BOOLEAN := TRUE;--Added for bug # 5647107
4746: --Added Bug # 5647107 ssdeshpa start
4747: CURSOR l_systemparams_csr IS
4748: SELECT NVL(tax_upfront_yn,'N')
4749: FROM OKL_SYSTEM_PARAMS;
4750:
4751: l_ou_tax_upfront_yn VARCHAR2(1);
4752: --Added Bug # 5647107 ssdeshpa end
4753: