1906: , inbk.deprn_method_code
1907: , inbk.life_in_months
1908: , inbk.adjusted_rate
1909: , inbk.production_capacity
1910: from fa_transaction_headers th
1911: , fa_books inbk
1912: , fa_books outbk
1913: , fa_calendar_types ct
1914: , fa_calendar_periods cp
1974: where ds.deprn_reserve = 0
1975: and ds.book_type_code = p_book_type_code
1976: and ds.asset_id = p_asset_id
1977: and ds.deprn_source_code = 'BOOKS')
1978: and not exists(select 1 from fa_transaction_headers th2
1979: where asset_id = p_asset_id
1980: and book_type_code = p_book_type_code
1981: and transaction_type_code not in ('TRANSFER OUT', 'TRANSFER IN',
1982: 'TRANSFER', 'TRANSFER IN/VOID',