DBA Data[Home] [Help]

APPS.FA_ADJUSTMENT_PUB dependencies on FA_BOOKS

Line 226: from fa_books

222: select deprn_method_code,
223: life_in_months
224: into l_deprn_method_code,
225: l_life_in_months
226: from fa_books
227: where book_type_code = px_asset_hdr_rec.book_type_code
228: and asset_id = px_asset_hdr_rec.asset_id
229: and transaction_header_id_out is null;
230:

Line 668: from fa_books bk_old, fa_books bk_extnd

664: bk_old.adjusted_rate,
665: bk_old.allowed_deprn_limit,
666: bk_old.deprn_limit_type,
667: bk_old.allowed_deprn_limit_amount
668: from fa_books bk_old, fa_books bk_extnd
669: where bk_old.book_type_code = p_book_type_code and
670: bk_old.asset_id = p_asset_id and
671: bk_old.extended_depreciation_period is null and
672: bk_extnd.book_type_code = p_book_type_code and