DBA Data[Home] [Help]

APPS.FA_MASSCP_PKG dependencies on FA_DEPRN_PERIODS

Line 576: fa_deprn_periods dp,

572:
573: select count(*)
574: into l_count
575: from fa_books corp_bk,
576: fa_deprn_periods dp,
577: fa_transaction_headers corp_th
578: where corp_bk.transaction_header_id_in = corp_th.transaction_header_id
579: and corp_bk.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
580: and corp_bk.asset_id = p_asset_id

Line 2614: fa_deprn_periods dp,

2610: books.transaction_header_id_in,
2611: books.period_counter_fully_retired
2612: from fa_books books,
2613: fa_additions_b ad,
2614: fa_deprn_periods dp,
2615: fa_asset_history ah -- bug fix 5925965
2616: where books.date_effective <= nvl(l_corp_period_rec.period_close_date, sysdate)
2617: and nvl(books.date_ineffective, sysdate) > nvl(l_corp_period_rec.period_close_date, sysdate - 1)
2618: and books.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book