APPS.FA_AMORT_PKG dependencies on FA_TRANSACTION_HEADERS

Line 374: (select 1 from fa_transaction_headers

370: cursor check_period_of_addition is
371: select 'Y' -- 'Y' if the current period of the asset is period of addition.
372: from dual
373: where exists
374: (select 1 from fa_transaction_headers
375: where transaction_type_code = 'ADDITION'
376: and transaction_header_id = X_fin_info_ptr.transaction_id);
377: -- Bug4560593: Commenting out
378: -- where not exists

Line 393: from fa_transaction_headers th, fa_deprn_periods dp

389:
390: -- multiple backdate amortization enhancement - begin LSON
391: cursor amort_date_before_add is
392: select th.transaction_header_id
393: from fa_transaction_headers th, fa_deprn_periods dp
394: where th.book_type_code = X_fin_info_ptr.book
395: and th.asset_id = X_fin_info_ptr.asset_id
396: and th.transaction_type_code = 'ADDITION'
397: and th.book_type_code = dp.book_type_code

Line 412: from fa_transaction_headers th

408: -- can be used or not
409: --
410: cursor c_check_fiscal_year (c_thid number) is
411: select 1
412: from fa_transaction_headers th
413: , fa_deprn_periods dp
414: , fa_fiscal_year fy
415: , fa_calendar_periods cp
416: where th.transaction_header_id = c_thid