1952: -- Get the OKL_TXD_ASSETS_B info
1953: CURSOR l_txd_csr(p_asset_num VARCHAR2)
1954: IS
1955: SELECT tax_book
1956: FROM okl_txd_assets_v txd
1957: WHERE txd.asset_number = p_asset_num;
1958: -- Get the types of TAX BOOKS defined in the setup
1959: -- We get first for the Federal or state
1960: CURSOR l_txtrans_csr (p_book fa_book_controls.book_type_code%TYPE)
22030: txd.life_in_months_tax,
22031: txd.salvage_value,
22032: txd.tax_book,
22033: mth.id1
22034: FROM okl_txd_assets_v txd,
22035: okx_asst_dep_methods_v mth
22036: WHERE mth.method_code = txd.deprn_method_tax
22037: AND mth.life_in_months = txd.life_in_months_tax
22038: AND txd.asset_number = ass;