DBA Data[Home] [Help]

APPS.FA_MC_UPG3_PKG dependencies on FA_MC_CONVERSION_RATES

Line 386: fa_mc_conversion_rates cr

382: aj.debit_credit_flag
383: FROM
384: fa_mc_adjustments maj,
385: fa_adjustments aj,
386: fa_mc_conversion_rates cr
387: WHERE
388: cr.set_of_books_id = p_rsob_id AND
389: maj.set_of_books_id = cr.set_of_books_id AND
390: cr.book_type_code = p_book_type_code AND

Line 559: FROM fa_mc_conversion_rates

555:
556:
557: CURSOR get_periods IS
558: SELECT distinct last_period_counter
559: FROM fa_mc_conversion_rates
560: WHERE
561: set_of_books_id = p_rsob_id AND
562: book_type_code = p_book_type_code;
563:

Line 589: fa_mc_conversion_rates cr

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
592: cr.set_of_books_id = p_rsob_id AND
593: cr.book_type_code = p_book_type_code AND

Line 984: fa_mc_conversion_rates cr

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
987: cr.book_type_code = p_book_type_code AND
988: cr.asset_id = dd.asset_id AND

Line 1229: fa_mc_conversion_rates cr

1225: dd.deferred_deprn_reserve_ccid
1226: FROM
1227: fa_deferred_deprn dd,
1228: fa_mc_deferred_deprn mdd,
1229: fa_mc_conversion_rates cr
1230: WHERE
1231: cr.set_of_books_id = p_rsob_id AND
1232: cr.book_type_code = p_book_type_code AND
1233: cr.asset_id = dd.asset_id AND

Line 1317: fa_mc_conversion_rates cr

1313: dd.deferred_deprn_expense_ccid
1314: FROM
1315: fa_deferred_deprn dd,
1316: fa_mc_deferred_deprn mdd,
1317: fa_mc_conversion_rates cr
1318: WHERE
1319: cr.set_of_books_id = p_rsob_id AND
1320: cr.book_type_code = p_book_type_code AND
1321: cr.asset_id = dd.asset_id AND