DBA Data[Home] [Help]

APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_SYS_ACCT_OPTS

Line 7768: OKL_SYS_ACCT_OPTS sys

7764: -- cursor to check valid corporate book tied to the ledger
7765: CURSOR l_corpbook_csr(p_book_type_code IN VARCHAR2) IS
7766: SELECT 'Y'
7767: FROM FA_BOOK_CONTROLS fa,
7768: OKL_SYS_ACCT_OPTS sys
7769: WHERE book_class='CORPORATE'
7770: AND fa.set_of_books_id = sys.set_of_books_id
7771: AND book_type_code = p_book_type_code;
7772:

Line 7863: okl_sys_acct_opts_all c

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

Line 7869: l_secondary_rep_method okl_sys_acct_opts_all.secondary_rep_method%TYPE;

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