DBA Data[Home] [Help]

APPS.FA_IMPAIRMENT_PREV_PVT dependencies on FA_BOOKS_SUMMARY_T

Line 3038: -- Preserve rows in FA_BOOKS_SUMMARY_T table for later use

3034:
3035: END LOOP; -- i in 1..fa_amort_pvt.t_period_counter.count
3036:
3037: --
3038: -- Preserve rows in FA_BOOKS_SUMMARY_T table for later use
3039: --
3040: if (p_log_level_rec.statement_level) then
3041: fa_debug_pkg.add(l_calling_fn,'Inserting into FA_BOOKS_SUMMARY_T',
3042: fa_amort_pvt.t_period_counter.count, p_log_level_rec => p_log_level_rec);

Line 3041: fa_debug_pkg.add(l_calling_fn,'Inserting into FA_BOOKS_SUMMARY_T',

3037: --
3038: -- Preserve rows in FA_BOOKS_SUMMARY_T table for later use
3039: --
3040: if (p_log_level_rec.statement_level) then
3041: fa_debug_pkg.add(l_calling_fn,'Inserting into FA_BOOKS_SUMMARY_T',
3042: fa_amort_pvt.t_period_counter.count, p_log_level_rec => p_log_level_rec);
3043: end if;
3044:
3045: FORALL i in 1..fa_amort_pvt.t_period_counter.count

Line 3046: INSERT INTO FA_BOOKS_SUMMARY_T(

3042: fa_amort_pvt.t_period_counter.count, p_log_level_rec => p_log_level_rec);
3043: end if;
3044:
3045: FORALL i in 1..fa_amort_pvt.t_period_counter.count
3046: INSERT INTO FA_BOOKS_SUMMARY_T(
3047: REQUEST_ID
3048: , IMPAIRMENT_ID
3049: , ASSET_ID
3050: , BOOK_TYPE_CODE

Line 3371: FROM fa_books_summary_t

3367: -- , POLISH_ADJ_REC_COST
3368: , IMPAIRMENT_AMOUNT
3369: , YTD_IMPAIRMENT
3370: , IMPAIRMENT_RESERVE
3371: FROM fa_books_summary_t
3372: WHERE asset_id = c_asset_id
3373: AND book_type_code = p_book_type_code
3374: AND period_counter >= p_imp_period_rec.period_counter
3375: AND request_id = p_request_id