APPS.JA_CN_PS_FA_AC_EXP_PKG dependencies on FA_DEPRN_SUMMARY

Line 656: fa_deprn_summary

652: nvl(MAX(period_counter), 0)
653: INTO
654: ln_real_deprn_counter
655: FROM
656: fa_deprn_summary
657: WHERE asset_id = lv_asset_id
658: AND book_type_code = lv_book_type_code
659: AND deprn_source_code = 'DEPRN';
660:

Line 775: FROM fa_deprn_summary

771: , ln_impairment_rsv
772: , ln_life_production
773: , ln_monthly_deprn_amount
774: , ln_mth_impairment_amount
775: FROM fa_deprn_summary
776: WHERE asset_id = lv_asset_id
777: AND period_counter = ln_depreciation_counter
778: AND book_type_code = lv_book_type_code;
779:

Line 866: FROM fa_deprn_summary fds

862: SELECT nvl(fds.deprn_reserve, 0)
863: , nvl(fds.impairment_reserve, 0)
864: INTO ln_deprn_rsv_last
865: , ln_impt_rsv_last
866: FROM fa_deprn_summary fds
867: WHERE fds.asset_id = lv_asset_id
868: AND fds.book_type_code = lv_book_type_code
869: AND fds.period_counter =
870: (SELECT MAX(period_counter)

Line 871: FROM fa_deprn_summary fds2

867: WHERE fds.asset_id = lv_asset_id
868: AND fds.book_type_code = lv_book_type_code
869: AND fds.period_counter =
870: (SELECT MAX(period_counter)
871: FROM fa_deprn_summary fds2
872: WHERE fds2.asset_id = lv_asset_id
873: AND fds2.book_type_code = lv_book_type_code
874: AND fds2.period_counter < ln_depreciation_counter);
875: ln_deprn_reserve := ln_deprn_rsv_last + ln_monthly_deprn_amount;

Line 940: FROM fa_deprn_summary

936:
937: --calculate the dpreciated months after addition.
938: SELECT COUNT(period_counter)
939: INTO ln_dep_month
940: FROM fa_deprn_summary
941: WHERE asset_id = lv_asset_id
942: AND period_counter <= ln_depreciation_counter
943: AND book_type_code = lv_book_type_code
944: AND deprn_source_code = 'DEPRN'