DBA Data[Home] [Help]

APPS.FA_ADJUSTMENT_PUB dependencies on FA_DEPRN_PERIODS

Line 770: , fa_deprn_periods fadp

766: ) is
767: Select 1
768: from
769: fa_transaction_headers fath
770: , fa_deprn_periods fadp
771: , fa_retirements faret
772: , fa_conventions facon
773: where fath.book_type_code = p_book_type_code
774: and fath.asset_id = p_asset_id

Line 796: from fa_deprn_periods

792: --Bug# 7715678
793: cursor c_get_context_date(c_book_type_code varchar2) is
794: select greatest(calendar_period_open_date,
795: least(sysdate, calendar_period_close_date))
796: from fa_deprn_periods
797: where book_type_code = c_book_type_code
798: and period_close_date is null;
799:
800: --Bug 8941132 MRC RECLASS