APPS.OKL_QA_DATA_INTEGRITY dependencies on FA_BOOK_CONTROLS

Line 8094: FROM fa_book_controls

8090:
8091: --Bug#3877032
8092: CURSOR l_rpt_csr( bk VARCHAR2, dat DATE ) IS
8093: SELECT 'Y'
8094: FROM fa_book_controls
8095: WHERE book_class = 'TAX'
8096: --and nvl(initial_date,dat) <= dat Bug#3636801
8097: AND NVL(date_ineffective,dat+1) > dat
8098: AND book_type_code = bk;

Line 8148: AND sgn.jtot_object1_code = 'FA_BOOK_CONTROLS'

8144: okl_txl_assets_b txl,
8145: okl_sgn_translations sgn
8146: WHERE txd.tal_id = txl.id
8147: AND txl.kle_id = Kleid
8148: AND sgn.jtot_object1_code = 'FA_BOOK_CONTROLS'
8149: AND sgn.object1_id1 = txd.tax_book
8150: AND sgn.sgn_code = 'STMP' -- Bug# 3533552
8151: GROUP BY sgn.value;
8152:

Line 8184: FROM FA_BOOK_CONTROLS fa,

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

Line 12071: WHERE sgn.jtot_object1_code = 'FA_BOOK_CONTROLS'

12067: --Bug#3877032
12068: CURSOR l_check_tax_map_for_asset(p_tax_book VARCHAR2 ) IS
12069: SELECT 'Y'
12070: FROM okl_sgn_translations sgn
12071: WHERE sgn.jtot_object1_code = 'FA_BOOK_CONTROLS'
12072: AND sgn.object1_id1 = p_tax_book
12073: AND sgn.sgn_code = 'STMP';
12074:
12075: l_assets_txl_lines_rec l_assets_txl_lines%ROWTYPE;