APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_SYS_ACCT_OPTS

Line 8185: OKL_SYS_ACCT_OPTS sys

8181: -- cursor to check valid corporate book tied to the ledger
8182: CURSOR l_corpbook_csr(p_book_type_code IN VARCHAR2) IS
8183: SELECT 'Y'
8184: FROM FA_BOOK_CONTROLS fa,
8185: OKL_SYS_ACCT_OPTS sys
8186: WHERE book_class='CORPORATE'
8187: AND fa.set_of_books_id = sys.set_of_books_id
8188: AND book_type_code = p_book_type_code;
8189:

Line 8280: okl_sys_acct_opts_all c

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
8283: AND c.org_id = a.org_id;
8284:

Line 8286: l_secondary_rep_method okl_sys_acct_opts_all.secondary_rep_method%TYPE;

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
8290: pdt.reporting_pdt_id

Line 13744: FROM okl_sys_acct_opts;

13740: l_chk_rbk_rec l_chk_rbk_csr%ROWTYPE;
13741:
13742: CURSOR l_sys_acct_opts_csr IS
13743: SELECT NVL(amort_inc_adj_rev_dt_yn,'N') amort_inc_adj_rev_dt_yn
13744: FROM okl_sys_acct_opts;
13745:
13746: l_sys_acct_opts_rec l_sys_acct_opts_csr%ROWTYPE;
13747:
13748: CURSOR l_fin_asset_csr(p_chr_id in number) is

Line 13931: FROM okl_sys_acct_opts;

13927: l_chk_rbk_rec l_chk_rbk_csr%ROWTYPE;
13928:
13929: CURSOR l_sys_acct_opts_csr IS
13930: SELECT NVL(amort_inc_adj_rev_dt_yn,'N') amort_inc_adj_rev_dt_yn
13931: FROM okl_sys_acct_opts;
13932:
13933: l_sys_acct_opts_rec l_sys_acct_opts_csr%ROWTYPE;
13934:
13935: CURSOR l_payment_hdr_csr