DBA Data[Home] [Help]

APPS.FA_UTIL_PVT dependencies on FA_DEPRN_SUMMARY

Line 963: p_period_counter IN FA_DEPRN_SUMMARY.period_counter%TYPE DEFAULT NULL,

959:
960: FUNCTION get_asset_deprn_rec
961: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
962: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
963: p_period_counter IN FA_DEPRN_SUMMARY.period_counter%TYPE DEFAULT NULL,
964: p_mrc_sob_type_code IN VARCHAR2
965: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
966: ) RETURN BOOLEAN IS
967:

Line 2394: FROM fa_deprn_summary ds,

2390: else
2391:
2392: SELECT nvl(ds.system_deprn_amount,0)
2393: INTO l_deprn_amt
2394: FROM fa_deprn_summary ds,
2395: fa_book_controls bc
2396: WHERE bc.book_type_code = X_book
2397: AND ds.book_type_code = bc.book_type_code
2398: AND ds.period_counter = bc.last_period_counter + 1

Line 2409: FROM fa_deprn_summary ds,

2405: else
2406:
2407: select nvl(ds.system_deprn_amount,0)
2408: into l_deprn_amt
2409: FROM fa_deprn_summary ds,
2410: fa_book_controls bc,
2411: fa_books bks,
2412: fa_additions_b ad
2413: WHERE bc.book_type_code = X_Book