APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_SYSTEM_PARAMS_ALL

Line 8278: FROM okl_system_params_all a,

8274:
8275: CURSOR system_corp_book_csr(p_chr_id NUMBER) IS
8276: SELECT A.ASST_ADD_BOOK_TYPE_CODE,
8277: C.secondary_rep_method secondary_rep_method
8278: FROM okl_system_params_all a,
8279: okc_k_headers_all_b b,
8280: okl_sys_acct_opts_all c
8281: WHERE b.id = p_chr_id
8282: AND b.authoring_org_id = a.org_id

Line 8285: l_system_corp_book okl_system_params_all.ASST_ADD_BOOK_TYPE_CODE%TYPE;

8281: WHERE b.id = p_chr_id
8282: AND b.authoring_org_id = a.org_id
8283: AND c.org_id = a.org_id;
8284:
8285: l_system_corp_book okl_system_params_all.ASST_ADD_BOOK_TYPE_CODE%TYPE;
8286: l_secondary_rep_method okl_sys_acct_opts_all.secondary_rep_method%TYPE;
8287:
8288: CURSOR chk_rpt_prod_id (p_chr_id IN NUMBER) IS
8289: SELECT

Line 8400: l_report_tax_book := OKL_SYSTEM_PARAMS_ALL_PUB.get_system_param_value(OKL_SYSTEM_PARAMS_ALL_PUB.G_RPT_PROD_BOOK_TYPE_CODE);

8396:
8397: --bug# 2753114
8398: IF( l_hdr.report_pdt_id <> -1 ) THEN
8399:
8400: l_report_tax_book := OKL_SYSTEM_PARAMS_ALL_PUB.get_system_param_value(OKL_SYSTEM_PARAMS_ALL_PUB.G_RPT_PROD_BOOK_TYPE_CODE);
8401:
8402: OPEN l_rpt_csr( l_report_tax_book, l_hdr.start_date );
8403: FETCH l_rpt_csr INTO l_rpt_rec;
8404: --Bug#3877032