DBA Data[Home] [Help]

APPS.JA_CN_PS_FA_MI_EXP_PKG dependencies on FA_DEPRN_SUMMARY

Line 615: FROM fa_deprn_summary fds,

611: lv_change_content(1) := 'Impairment:';
612: SELECT fds1.impairment_reserve,
613: fds.impairment_reserve
614: INTO lv_before(1), lv_after(1)
615: FROM fa_deprn_summary fds,
616: fa_deprn_summary fds1,
617: fa_deprn_periods fdp
618: WHERE fds.asset_id = v_row.asset_id
619: AND fds1.asset_id = v_row.asset_id

Line 616: fa_deprn_summary fds1,

612: SELECT fds1.impairment_reserve,
613: fds.impairment_reserve
614: INTO lv_before(1), lv_after(1)
615: FROM fa_deprn_summary fds,
616: fa_deprn_summary fds1,
617: fa_deprn_periods fdp
618: WHERE fds.asset_id = v_row.asset_id
619: AND fds1.asset_id = v_row.asset_id
620: AND fdp.book_type_code = v_row.book_type_code

Line 629: FROM fa_deprn_summary

625: fdp.calendar_period_close_date
626: AND fds.period_counter = fdp.period_counter
627: AND fds1.period_counter =
628: (SELECT MAX(period_counter)
629: FROM fa_deprn_summary
630: WHERE asset_id = v_row.asset_id
631: AND book_type_code = v_row.book_type_code
632: AND period_counter < fdp.period_counter);
633: lv_before(1) := ja_cn_utility.get_rounding_value