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