DBA Data[Home] [Help]

APPS.FA_AMORT_PKG dependencies on FA_DEPRN_PERIODS

Line 411: from fa_transaction_headers th, fa_deprn_periods dp

407:
408: -- multiple backdate amortization enhancement - begin LSON
409: cursor amort_date_before_add is
410: select th.transaction_header_id
411: from fa_transaction_headers th, fa_deprn_periods dp
412: where th.book_type_code = X_fin_info_ptr.book
413: and th.asset_id = X_fin_info_ptr.asset_id
414: and th.transaction_type_code = 'ADDITION'
415: and th.book_type_code = dp.book_type_code

Line 431: , fa_deprn_periods dp

427: --
428: cursor c_check_fiscal_year (c_thid number) is
429: select 1
430: from fa_transaction_headers th
431: , fa_deprn_periods dp
432: , fa_fiscal_year fy
433: , fa_calendar_periods cp
434: where th.transaction_header_id = c_thid
435: and th.date_effective between dp.period_open_date and