APPS.JA_CN_FA_AC_EXPORT_PKG dependencies on FA_DEPRN_SUMMARY

Line 729: FROM fa_deprn_summary

725: AND dp.period_close_date IS NOT NULL;
726: --get the period counter from depreciation summary.
727: SELECT nvl(MAX(period_counter), 0)
728: INTO ln_real_deprn_counter
729: FROM fa_deprn_summary
730: WHERE asset_id = lv_asset_id
731: AND book_type_code = lv_book_type_code
732: AND deprn_source_code = 'DEPRN';
733:

Line 830: FROM fa_deprn_summary

826: ln_impairment_rsv,
827: ln_life_production,
828: ln_monthly_deprn_amount,
829: ln_mth_impairment_amount
830: FROM fa_deprn_summary
831: WHERE asset_id = lv_asset_id
832: AND period_counter = ln_depreciation_counter
833: AND book_type_code = lv_book_type_code;
834:

Line 916: FROM fa_deprn_summary fds

912:
913: SELECT nvl(fds.deprn_reserve, 0),
914: nvl(fds.impairment_reserve, 0)
915: INTO ln_deprn_rsv_last, ln_impt_rsv_last
916: FROM fa_deprn_summary fds
917: WHERE fds.asset_id = lv_asset_id
918: AND fds.book_type_code = lv_book_type_code
919: AND fds.period_counter =
920: (SELECT MAX(period_counter)

Line 921: FROM fa_deprn_summary fds2

917: WHERE fds.asset_id = lv_asset_id
918: AND fds.book_type_code = lv_book_type_code
919: AND fds.period_counter =
920: (SELECT MAX(period_counter)
921: FROM fa_deprn_summary fds2
922: WHERE fds2.asset_id = lv_asset_id
923: AND fds2.book_type_code = lv_book_type_code
924: AND fds2.period_counter < ln_depreciation_counter);
925:

Line 1001: FROM fa_deprn_summary

997:
998: --calculate the dpreciated months after addition.
999: SELECT COUNT(period_counter)
1000: INTO ln_dep_month
1001: FROM fa_deprn_summary
1002: WHERE asset_id = lv_asset_id
1003: AND period_counter <= ln_depreciation_counter
1004: AND book_type_code = lv_book_type_code
1005: AND deprn_source_code = 'DEPRN'