DBA Data[Home] [Help]

APPS.JA_CN_PS_FA_AC_EXP_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 300: , fa_distribution_history fdh

296: , fa_books bk
297: , fa_book_controls_sec fbc
298: , fa_category_books fcb
299: , fa_methods mth
300: , fa_distribution_history fdh
301: , gl_ledgers gl
302: , fa_transaction_history_trx_v fthv
303: , fnd_currencies_vl fncv
304: -- Check ledger

Line 784: FROM fa_distribution_history fdh

780:
781: --get the assigned unit
782: SELECT SUM(fdh.units_assigned)
783: INTO ln_assigned_unit
784: FROM fa_distribution_history fdh
785: WHERE fdh.asset_id = lv_asset_id
786: AND fdh.date_effective < nvl((SELECT MAX(fdp.period_close_date)
787: FROM fa_deprn_periods fdp
788: WHERE fdp.book_type_code = lv_book_type_code

Line 880: FROM fa_distribution_history fdh

876: ln_impairment_rsv := ln_impt_rsv_last + ln_mth_impairment_amount;
877: --get the total unit
878: SELECT SUM(fdh.units_assigned)
879: INTO ln_asset_unit
880: FROM fa_distribution_history fdh
881: WHERE fdh.asset_id = lv_asset_id
882: AND fdh.date_effective < nvl(
883: (SELECT MAX(fdp.period_close_date)
884: FROM fa_deprn_periods fdp

Line 898: FROM fa_distribution_history fdh

894: OR fdh.date_ineffective IS NULL);
895: --get the assigned unit
896: SELECT SUM(fdh.units_assigned)
897: INTO ln_assigned_unit
898: FROM fa_distribution_history fdh
899: WHERE fdh.asset_id = lv_asset_id
900: AND fdh.date_effective < nvl((SELECT MAX(fdp.period_close_date)
901: FROM fa_deprn_periods fdp
902: WHERE fdp.book_type_code = lv_book_type_code