DBA Data[Home] [Help]

APPS.FA_IMPAIRMENT_PREV_PVT dependencies on FA_TRANSACTION_HEADERS

Line 1910: from fa_transaction_headers th

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

Line 1978: and not exists(select 1 from fa_transaction_headers th2

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',