515: )
516: ) deprn_delta
517: FROM fa_deprn_summary deprn_sum,
518: fa_deprn_periods deprn_periods,
519: fa_impairments imp,
520: fa_itf_impairments itf
521: WHERE deprn_sum.book_type_code = deprn_periods.book_type_code
522: AND deprn_sum.period_counter = deprn_periods.period_counter
523: AND deprn_sum.period_counter = imp.period_counter_impaired
604: )
605: ) deprn_delta
606: FROM fa_deprn_summary deprn_sum,
607: fa_deprn_periods deprn_periods,
608: fa_impairments imp,
609: fa_itf_impairments itf
610: WHERE deprn_sum.book_type_code = deprn_periods.book_type_code
611: AND deprn_sum.period_counter = deprn_periods.period_counter
612: AND deprn_sum.period_counter = imp.period_counter_impaired
628: 2
629: ) deprn_delta
630: FROM fa_deprn_summary deprn_sum,
631: fa_deprn_periods deprn_periods,
632: fa_impairments imp,
633: fa_itf_impairments itf
634: WHERE deprn_sum.book_type_code = deprn_periods.book_type_code
635: AND deprn_sum.period_counter = deprn_periods.period_counter
636: AND deprn_sum.period_counter = imp.period_counter_impaired