DBA Data[Home] [Help]

APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_SGN_TRANSLATIONS

Line 8145: okl_sgn_translations sgn

8141: sgn.value book_type,
8142: COUNT(*) book_count
8143: FROM Okl_txd_assets_v txd,
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

Line 12070: FROM okl_sgn_translations sgn

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