APPS.JA_CN_FA_AC_EXPORT_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 429: fa_distribution_history fdh,

425: fa_books bk,
426: fa_book_controls_sec fbc,
427: fa_category_books fcb,
428: fa_methods mth,
429: fa_distribution_history fdh,
430: gl_ledgers gl,
431: fa_transaction_history_trx_v fthv,
432: fnd_currencies_vl fncv
433: -- Check ledger

Line 838: FROM fa_distribution_history fdh

834:
835: --get the assigned unit
836: SELECT SUM(fdh.units_assigned)
837: INTO ln_assigned_unit
838: FROM fa_distribution_history fdh
839: WHERE fdh.asset_id = lv_asset_id
840: AND fdh.date_effective <
841: nvl((SELECT MAX(fdp.period_close_date)
842: FROM fa_deprn_periods fdp

Line 934: FROM fa_distribution_history fdh

930:
931: --get the total unit
932: SELECT SUM(fdh.units_assigned)
933: INTO ln_asset_unit
934: FROM fa_distribution_history fdh
935: WHERE fdh.asset_id = lv_asset_id
936: AND fdh.date_effective <
937: nvl((SELECT MAX(fdp.period_close_date)
938: FROM fa_deprn_periods fdp

Line 955: FROM fa_distribution_history fdh

951: SYSDATE) OR fdh.date_ineffective IS NULL);
952: --get the assigned unit
953: SELECT SUM(fdh.units_assigned)
954: INTO ln_assigned_unit
955: FROM fa_distribution_history fdh
956: WHERE fdh.asset_id = lv_asset_id
957: AND fdh.date_effective <
958: nvl((SELECT MAX(fdp.period_close_date)
959: FROM fa_deprn_periods fdp