APPS.OKL_LA_STREAM_PVT dependencies on OKL_SYSTEM_PARAMS_ALL

Line 2086: AND book_type_code = OKL_SYSTEM_PARAMS_ALL_PUB.get_system_param_value(OKL_SYSTEM_PARAMS_ALL_PUB.G_RPT_PROD_BOOK_TYPE_CODE);

2082: SELECT 'Y'
2083: FROM fa_book_controls
2084: WHERE book_class = 'TAX'
2085: AND mass_copy_source_book = p_corp_book
2086: AND book_type_code = OKL_SYSTEM_PARAMS_ALL_PUB.get_system_param_value(OKL_SYSTEM_PARAMS_ALL_PUB.G_RPT_PROD_BOOK_TYPE_CODE);
2087:
2088: BEGIN
2089: --OPEN get_rep_tax_csr(p_asset_number => p_asset_number);
2090: OPEN get_rep_tax_csr(p_corp_book => p_corp_book);

Line 6661: FROM OKL_SYSTEM_PARAMS_ALL;

6657:
6658: --To check whether the accrual flag is checked or not
6659: CURSOR check_accrual_previous_csr IS
6660: SELECT NVL(CHK_ACCRUAL_PREVIOUS_MNTH_YN,'N')
6661: FROM OKL_SYSTEM_PARAMS_ALL;
6662:
6663: CURSOR chk_curr_terminated_line(p_kle_id IN OKC_K_LINES_B.ID%TYPE) IS
6664: SELECT 'Y'
6665: FROM okc_k_headers_b CHR,