APPS.JA_CN_FA_MI_EXPORT_PKG dependencies on FA_DEPRN_SUMMARY

Line 571: FROM fa_deprn_summary fds,

567: lv_change_content(1) := 'Impairment:';
568: SELECT fds1.impairment_reserve,
569: fds.impairment_reserve
570: INTO lv_before(1), lv_after(1)
571: FROM fa_deprn_summary fds,
572: fa_deprn_summary fds1,
573: fa_deprn_periods fdp
574: WHERE fds.asset_id = v_row.asset_id and fds1.asset_id = v_row.asset_id
575: AND fdp.book_type_code = v_row.book_type_code

Line 572: fa_deprn_summary fds1,

568: SELECT fds1.impairment_reserve,
569: fds.impairment_reserve
570: INTO lv_before(1), lv_after(1)
571: FROM fa_deprn_summary fds,
572: fa_deprn_summary fds1,
573: fa_deprn_periods fdp
574: WHERE fds.asset_id = v_row.asset_id and fds1.asset_id = v_row.asset_id
575: AND fdp.book_type_code = v_row.book_type_code
576: AND fdp.book_type_code = fds.book_type_code

Line 582: FROM fa_deprn_summary

578: AND v_row.transaction_date BETWEEN fdp.calendar_period_open_date AND
579: fdp.calendar_period_close_date
580: AND fds.period_counter = fdp.period_counter
581: AND fds1.period_counter = (SELECT MAX(period_counter)
582: FROM fa_deprn_summary
583: WHERE asset_id = v_row.asset_id
584: AND book_type_code = v_row.book_type_code
585: AND period_counter < fdp.period_counter);
586: