APPS.FA_ADJUSTMENT_PUB dependencies on FA_BOOKS

Line 289: from fa_books

285: select deprn_method_code,
286: life_in_months
287: into l_deprn_method_code,
288: l_life_in_months
289: from fa_books
290: where book_type_code = px_asset_hdr_rec.book_type_code
291: and asset_id = px_asset_hdr_rec.asset_id
292: and transaction_header_id_out is null;
293:

Line 716: from fa_books bk_old, fa_books bk_extnd

712: NVL(bk_extnd.prior_adjusted_rate, bk_old.adjusted_rate) adjusted_rate,
713: bk_old.allowed_deprn_limit,
714: bk_old.deprn_limit_type,
715: bk_old.allowed_deprn_limit_amount
716: from fa_books bk_old, fa_books bk_extnd
717: where bk_old.book_type_code = p_book_type_code and
718: bk_old.asset_id = p_asset_id and
719: bk_old.extended_depreciation_period is null and
720: bk_extnd.book_type_code = p_book_type_code and

Line 733: FROM FA_BOOKS FB

729: , FB.adjusted_rate
730: , FB.allowed_deprn_limit
731: , FB.deprn_limit_type
732: , FB.allowed_deprn_limit_amount
733: FROM FA_BOOKS FB
734: , FA_TRANSACTION_HEADERS FT
735: WHERE FB.BOOK_TYPE_CODE = p_book_type_code
736: AND FB.ASSET_ID = p_asset_id
737: AND FB.BOOK_TYPE_CODE = FT.BOOK_TYPE_CODE

Line 749: FROM FA_BOOKS FB

745: , FB.prior_adjusted_rate
746: , FB.prior_deprn_limit
747: , FB.prior_deprn_limit_type
748: , FB.prior_deprn_limit_amount
749: FROM FA_BOOKS FB
750: WHERE FB.BOOK_TYPE_CODE = p_book_type_code
751: AND FB.ASSET_ID = p_asset_id
752: AND FB.date_ineffective IS NULL;
753: