APPS.FA_MC_UPG3_PKG dependencies on FA_DEPRN_DETAIL

Line 587: fa_deprn_detail dd,

583: SELECT
584: sum(mdd.deprn_reserve),
585: sum(dd.deprn_reserve)
586: FROM
587: fa_deprn_detail dd,
588: fa_mc_deprn_detail mdd,
589: fa_mc_conversion_rates cr
590: WHERE
591: cr.last_period_counter = l_pc AND

Line 660: fa_deprn_detail dd,

656: l_dist_ccid,
657: l_rsv_account,
658: l_account_ccid
659: FROM
660: fa_deprn_detail dd,
661: fa_category_books cb,
662: fa_asset_history ah,
663: fa_distribution_history dh
664: WHERE

Line 841: fa_deprn_detail dd,

837: SELECT
838: nvl(sum(dd.deprn_amount),0),
839: nvl(sum(mdd.deprn_amount),0)
840: FROM
841: fa_deprn_detail dd,
842: fa_mc_deprn_detail mdd
843: WHERE
844: mdd.period_counter = l_pc AND
845: mdd.set_of_books_id = p_rsob_id AND

Line 982: fa_deprn_detail dd,

978: nvl(sum(dd.reval_reserve),0),
979: nvl(sum(mdd.reval_reserve),0)
980: FROM
981: fa_adjustments aj,
982: fa_deprn_detail dd,
983: fa_mc_deprn_detail mdd,
984: fa_mc_conversion_rates cr
985: WHERE
986: cr.set_of_books_id = p_rsob_id AND

Line 1121: fa_deprn_detail dd

1117: nvl(sum(dd.reval_amortization),0),
1118: nvl(sum(mdd.reval_amortization),0)
1119: FROM
1120: fa_mc_deprn_detail mdd,
1121: fa_deprn_detail dd
1122: WHERE
1123: mdd.book_type_code = p_book_type_code AND
1124: mdd.period_counter = l_pc AND
1125: mdd.set_of_books_id = p_rsob_id AND