DBA Data[Home] [Help]

APPS.IGI_IAC_REVAL_UTILITIES dependencies on FA_ADDITIONS

Line 483: , fa_additions fadd

479: cursor c_deprn_asset is
480: select fds.asset_id, fds.book_type_code, fds.period_counter + 1, abs(fds.ytd_deprn) ytd_deprn, fdp.fiscal_year
481: , fadd.current_units total_units
482: from fa_deprn_summary fds, fa_deprn_periods fdp
483: , fa_additions fadd
484: where fds.book_type_code = fp_book_type_code
485: and fdp.book_type_code = fds.book_type_code
486: and fdp.period_counter = fds.period_counter
487: -- and fds.period_counter <= fp_current_period_counter

Line 517: , fa_additions fadd

513: (fdh.units_assigned/fadd.current_units) ytd_prorate_factor,
514: (fdh.units_assigned/fadd.current_units) normal_prorate_factor
515: from fa_deprn_periods fdp
516: , fa_distribution_history fdh
517: , fa_additions fadd
518: , fa_transaction_headers fth
519: where fth.book_type_code = cp_book_type_code
520: and fdp.book_type_code = fth.book_type_code
521: and fdh.asset_id = fth.asset_id