DBA Data[Home] [Help]

APPS.IGI_IAC_REVAL_UTILITIES dependencies on FA_DEPRN_SUMMARY

Line 482: from fa_deprn_summary fds, fa_deprn_periods fdp

478:
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

Line 491: from fa_deprn_summary

487: -- and fds.period_counter <= fp_current_period_counter
488: and fds.asset_id = fp_asset_id
489: and fadd.asset_id = fp_asset_id
490: and fds.period_counter in ( select max(period_counter)
491: from fa_deprn_summary
492: where book_type_code = fds.book_type_code
493: and asset_id = fds.asset_id
494: )
495: ;

Line 667: FROM fa_deprn_summary fds

663: AND fb.transaction_header_id_out IS NULL;
664:
665: CURSOR C_first_deprn_period IS
666: SELECT min(fds.period_counter)
667: FROM fa_deprn_summary fds
668: WHERE fds.book_type_code = fp_book_type_code
669: AND fds.asset_id = fp_asset_id
670: AND fds.deprn_source_code = 'DEPRN';
671:

Line 885: FROM fa_deprn_summary fds

881: AND fb.transaction_header_id_out IS NULL;
882:
883: CURSOR C_first_deprn_period IS
884: SELECT min(fds.period_counter)
885: FROM fa_deprn_summary fds
886: WHERE fds.book_type_code = fp_book_type_code
887: AND fds.asset_id = fp_asset_id
888: AND fds.deprn_source_code = 'DEPRN';
889: