574: SELECT
575: sum(mdd.deprn_reserve),
576: sum(dd.deprn_reserve)
577: FROM
578: fa_deprn_detail dd,
579: fa_mc_deprn_detail mdd,
580: fa_mc_conversion_rates cr
581: WHERE
582: cr.last_period_counter = l_pc AND
647: l_dist_ccid,
648: l_rsv_account,
649: l_account_ccid
650: FROM
651: fa_deprn_detail dd,
652: fa_category_books cb,
653: fa_asset_history ah,
654: fa_distribution_history dh
655: WHERE
828: SELECT
829: nvl(sum(dd.deprn_amount),0),
830: nvl(sum(mdd.deprn_amount),0)
831: FROM
832: fa_deprn_detail dd,
833: fa_mc_deprn_detail mdd
834: WHERE
835: mdd.period_counter = l_pc AND
836: mdd.set_of_books_id = p_rsob_id AND
969: nvl(sum(dd.reval_reserve),0),
970: nvl(sum(mdd.reval_reserve),0)
971: FROM
972: fa_adjustments aj,
973: fa_deprn_detail dd,
974: fa_mc_deprn_detail mdd,
975: fa_mc_conversion_rates cr
976: WHERE
977: cr.set_of_books_id = p_rsob_id AND
1108: nvl(sum(dd.reval_amortization),0),
1109: nvl(sum(mdd.reval_amortization),0)
1110: FROM
1111: fa_mc_deprn_detail mdd,
1112: fa_deprn_detail dd
1113: WHERE
1114: mdd.book_type_code = p_book_type_code AND
1115: mdd.period_counter = l_pc AND
1116: mdd.set_of_books_id = p_rsob_id AND