DBA Data[Home] [Help]

APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_SGN_TRANSLATIONS

Line 7728: okl_sgn_translations sgn

7724: sgn.value book_type,
7725: COUNT(*) book_count
7726: FROM Okl_txd_assets_v txd,
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

Line 11647: FROM okl_sgn_translations sgn

11643:
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: