APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_SYSTEM_PARAMS_ALL

Line 7861: FROM okl_system_params_all a,

7857:
7858: CURSOR system_corp_book_csr(p_chr_id NUMBER) IS
7859: SELECT A.ASST_ADD_BOOK_TYPE_CODE,
7860: C.secondary_rep_method secondary_rep_method
7861: FROM okl_system_params_all a,
7862: okc_k_headers_all_b b,
7863: okl_sys_acct_opts_all c
7864: WHERE b.id = p_chr_id
7865: AND b.authoring_org_id = a.org_id

Line 7868: l_system_corp_book okl_system_params_all.ASST_ADD_BOOK_TYPE_CODE%TYPE;

7864: WHERE b.id = p_chr_id
7865: AND b.authoring_org_id = a.org_id
7866: AND c.org_id = a.org_id;
7867:
7868: l_system_corp_book okl_system_params_all.ASST_ADD_BOOK_TYPE_CODE%TYPE;
7869: l_secondary_rep_method okl_sys_acct_opts_all.secondary_rep_method%TYPE;
7870:
7871: CURSOR chk_rpt_prod_id (p_chr_id IN NUMBER) IS
7872: SELECT

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

7979:
7980: --bug# 2753114
7981: IF( l_hdr.report_pdt_id <> -1 ) THEN
7982:
7983: l_report_tax_book := OKL_SYSTEM_PARAMS_ALL_PUB.get_system_param_value(OKL_SYSTEM_PARAMS_ALL_PUB.G_RPT_PROD_BOOK_TYPE_CODE);
7984:
7985: OPEN l_rpt_csr( l_report_tax_book, l_hdr.start_date );
7986: FETCH l_rpt_csr INTO l_rpt_rec;
7987: --Bug#3877032