APPS.OKL_QA_DATA_INTEGRITY dependencies on FA_BOOK_CONTROLS

Line 7677: FROM fa_book_controls

7673:
7674: --Bug#3877032
7675: CURSOR l_rpt_csr( bk VARCHAR2, dat DATE ) IS
7676: SELECT 'Y'
7677: FROM fa_book_controls
7678: WHERE book_class = 'TAX'
7679: --and nvl(initial_date,dat) <= dat Bug#3636801
7680: AND NVL(date_ineffective,dat+1) > dat
7681: AND book_type_code = bk;

Line 7731: AND sgn.jtot_object1_code = 'FA_BOOK_CONTROLS'

7727: okl_txl_assets_b txl,
7728: okl_sgn_translations sgn
7729: WHERE txd.tal_id = txl.id
7730: AND txl.kle_id = Kleid
7731: AND sgn.jtot_object1_code = 'FA_BOOK_CONTROLS'
7732: AND sgn.object1_id1 = txd.tax_book
7733: AND sgn.sgn_code = 'STMP' -- Bug# 3533552
7734: GROUP BY sgn.value;
7735:

Line 7767: FROM FA_BOOK_CONTROLS fa,

7763: --------------
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;

Line 11648: WHERE sgn.jtot_object1_code = 'FA_BOOK_CONTROLS'

11644: --Bug#3877032
11645: CURSOR l_check_tax_map_for_asset(p_tax_book VARCHAR2 ) IS
11646: SELECT 'Y'
11647: FROM okl_sgn_translations sgn
11648: WHERE sgn.jtot_object1_code = 'FA_BOOK_CONTROLS'
11649: AND sgn.object1_id1 = p_tax_book
11650: AND sgn.sgn_code = 'STMP';
11651:
11652: l_assets_txl_lines_rec l_assets_txl_lines%ROWTYPE;