APPS.FA_INS_DETAIL_PKG dependencies on FA_DEPRN_DETAIL

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 177: FROM fa_deprn_detail

173: else
174:
175: SELECT sum(nvl(deprn_adjustment_amount,0))
176: INTO h_deprn_adjustment_amount
177: FROM fa_deprn_detail
178: WHERE book_type_code = X_book_type_code
179: AND asset_id = X_asset_id
180: AND deprn_source_code = 'B';
181:

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 401: DELETE FROM fa_deprn_detail

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
401: DELETE FROM fa_deprn_detail
402: WHERE book_type_code = h_book_type_code AND
403: asset_id = h_asset_id AND
404: period_counter = h_period_counter;
405: end if; -- end mrc

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,

Line 626: INSERT INTO fa_deprn_detail(BOOK_TYPE_CODE,

622: h_part_bonus_deprn_reserve);
623:
624: else
625:
626: INSERT INTO fa_deprn_detail(BOOK_TYPE_CODE,
627: ASSET_ID,
628: DISTRIBUTION_ID,
629: PERIOD_COUNTER,
630: DEPRN_RUN_DATE,