DBA Data[Home] [Help]

APPS.FA_MC_UPG3_PKG dependencies on FA_MC_CONVERSION_RATES

Line 381: fa_mc_conversion_rates cr

377: aj.debit_credit_flag
378: FROM
379: fa_mc_adjustments maj,
380: fa_adjustments aj,
381: fa_mc_conversion_rates cr
382: WHERE
383: cr.set_of_books_id = p_rsob_id AND
384: maj.set_of_books_id = cr.set_of_books_id AND
385: cr.book_type_code = p_book_type_code AND

Line 550: FROM fa_mc_conversion_rates

546:
547:
548: CURSOR get_periods IS
549: SELECT distinct last_period_counter
550: FROM fa_mc_conversion_rates
551: WHERE
552: set_of_books_id = p_rsob_id AND
553: book_type_code = p_book_type_code;
554:

Line 580: fa_mc_conversion_rates cr

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

Line 975: fa_mc_conversion_rates cr

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

Line 1220: fa_mc_conversion_rates cr

1216: dd.deferred_deprn_reserve_ccid
1217: FROM
1218: fa_deferred_deprn dd,
1219: fa_mc_deferred_deprn mdd,
1220: fa_mc_conversion_rates cr
1221: WHERE
1222: cr.set_of_books_id = p_rsob_id AND
1223: cr.book_type_code = p_book_type_code AND
1224: cr.asset_id = dd.asset_id AND

Line 1308: fa_mc_conversion_rates cr

1304: dd.deferred_deprn_expense_ccid
1305: FROM
1306: fa_deferred_deprn dd,
1307: fa_mc_deferred_deprn mdd,
1308: fa_mc_conversion_rates cr
1309: WHERE
1310: cr.set_of_books_id = p_rsob_id AND
1311: cr.book_type_code = p_book_type_code AND
1312: cr.asset_id = dd.asset_id AND