APPS.FA_INS_DETAIL_PKG dependencies on FA_DEPRN_DETAIL_MRC_V

Line 168: FROM fa_deprn_detail_mrc_v

164: if (X_mrc_sob_type_code ='R') then
165:
166: SELECT sum(nvl(deprn_adjustment_amount,0))
167: INTO h_deprn_adjustment_amount
168: FROM fa_deprn_detail_mrc_v
169: WHERE book_type_code = X_book_type_code
170: AND asset_id = X_asset_id
171: AND deprn_source_code = 'B';
172:

Line 396: DELETE FROM fa_deprn_detail_mrc_v

392:
393: h_msg_name := NULL;
394:
395: if X_mrc_sob_type_code = 'R' then
396: DELETE FROM fa_deprn_detail_mrc_v
397: WHERE book_type_code = h_book_type_code AND
398: asset_id = h_asset_id AND
399: period_counter = h_period_counter;
400: else

Line 586: INSERT INTO fa_deprn_detail_mrc_v

582: ,p_log_level_rec => p_log_level_rec);
583: end if;
584:
585: if (X_mrc_sob_type_code = 'R') then
586: INSERT INTO fa_deprn_detail_mrc_v
587: (BOOK_TYPE_CODE,
588: ASSET_ID,
589: DISTRIBUTION_ID,
590: PERIOD_COUNTER,