DBA Data[Home] [Help]

APPS.FA_MASSCP_PKG dependencies on FA_DEPRN_PERIODS

Line 804: fa_deprn_periods dp,

800:
801: select count(*)
802: into l_count
803: from fa_books corp_bk,
804: fa_deprn_periods dp,
805: fa_transaction_headers corp_th
806: where corp_bk.transaction_header_id_in = corp_th.transaction_header_id
807: and corp_bk.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
808: and corp_bk.asset_id = p_asset_id

Line 2940: fa_deprn_periods dp,

2936: books.transaction_header_id_in,
2937: books.period_counter_fully_retired
2938: from fa_books books,
2939: fa_additions_b ad,
2940: fa_deprn_periods dp,
2941: fa_asset_history ah -- bug fix 5900321
2942: where books.date_effective <= nvl(l_corp_period_rec.period_close_date, sysdate)
2943: and nvl(books.date_ineffective, sysdate) > nvl(l_corp_period_rec.period_close_date, sysdate - 1)
2944: and books.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book