APPS.JA_CN_PS_FA_ACUI_EXP_PKG dependencies on FA_TRANSACTION_HISTORY_TRX_V

Line 241: , fa_transaction_history_trx_v fthv

237: fa_additions_v faav
238: , fa_books fb
239: , fa_book_controls_sec fbc
240: , fa_distribution_history fdh
241: , fa_transaction_history_trx_v fthv
242: WHERE fb.date_ineffective IS NULL
243: AND fb.transaction_header_id_out IS NULL
244: AND faav.asset_id = fb.asset_id
245: AND fb.book_type_code = fbc.book_type_code

Line 515: fa_transaction_history_trx_v fthv

511: COUNT(*)
512: INTO
513: ln_full_retirement_count
514: FROM
515: fa_transaction_history_trx_v fthv
516: WHERE fthv.asset_id = lv_asset_id
517: AND fthv.book_type_code = lv_corp_book
518: AND fthv.transaction_type_code = 'FULL RETIREMENT'
519: AND ((SELECT greatest(greatest(dp.calendar_period_open_date

Line 532: FROM fa_transaction_history_trx_v fthv

528: IF(ln_full_retirement_count <> 0)
529: THEN
530: --Check the reinstatement of the asset.
531: SELECT COUNT(*) INTO ln_reinstate_count
532: FROM fa_transaction_history_trx_v fthv
533: WHERE fthv.asset_id = lv_asset_id
534: AND fthv.book_type_code = lv_corp_book
535: AND fthv.transaction_type_code = 'REINSTATEMENT'
536: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,

Line 550: FROM fa_transaction_history_trx_v fthv

546: lb_retirement_flag := TRUE;
547: ELSE
548: --Retireve the greatest effective date of retirement. .
549: SELECT greatest(date_effective) INTO ld_retirement_date
550: FROM fa_transaction_history_trx_v fthv
551: WHERE fthv.asset_id = lv_asset_id
552: AND fthv.book_type_code = lv_corp_book
553: AND fthv.transaction_type_code = 'FULL RETIREMENT'
554: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,

Line 564: FROM fa_transaction_history_trx_v fthv

560: BETWEEN dp.period_open_date
561: AND nvl(dp.period_close_date, SYSDATE)) <= ld_end_date);
562: --Retireve the greatest effective date of reinstatement.
563: SELECT greatest(date_effective) INTO ld_reinstated_date
564: FROM fa_transaction_history_trx_v fthv
565: WHERE fthv.asset_id = lv_asset_id
566: AND fthv.book_type_code = lv_corp_book
567: AND fthv.transaction_type_code = 'REINSTATEMENT'
568: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,

Line 609: , fa_transaction_history_trx_v thv

605: INTO
606: ln_transaction_header_id
607: FROM
608: fa_deprn_periods dp
609: , fa_transaction_history_trx_v thv
610: WHERE asset_id = lv_asset_id
611: AND transaction_type_code = 'UNIT ADJUSTMENT'
612: AND thv.date_effective BETWEEN dp.period_open_date
613: AND nvl(dp.period_close_date, sysdate)