The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ytd_deprn, deprn_reserve,
reval_reserve, ytd_reval_deprn_expense,
bonus_ytd_deprn, bonus_deprn_reserve,
period_counter
INTO h_ytd,
h_deprn_reserve,
h_reval_reserve,
h_ytd_reval_dep_exp,
h_bonus_ytd,
h_bonus_deprn_reserve,
h_period_counter
FROM fa_deprn_summary_mrc_v
WHERE book_type_code = X_book_type_code
AND asset_id = X_asset_id
AND deprn_source_code = 'BOOKS';
SELECT decode(ad.asset_type,
'GROUP', 0,
bk.cost)
INTO h_cost
FROM FA_BOOKS_MRC_V bk,
FA_ADDITIONS_B ad
WHERE ad.asset_id = X_asset_id
AND ad.asset_id = bk.asset_id
AND bk.book_type_code = X_book_type_code
and bk.transaction_header_id_out is null;
SELECT ytd_deprn, deprn_reserve,
reval_reserve, ytd_reval_deprn_expense,
bonus_ytd_deprn, bonus_deprn_reserve,
period_counter
INTO h_ytd,
h_deprn_reserve,
h_reval_reserve,
h_ytd_reval_dep_exp,
h_bonus_ytd,
h_bonus_deprn_reserve,
h_period_counter
FROM fa_deprn_summary
WHERE book_type_code = X_book_type_code
AND asset_id = X_asset_id
AND deprn_source_code = 'BOOKS';
SELECT decode(ad.asset_type,
'GROUP', 0,
bk.cost)
INTO h_cost
FROM FA_BOOKS bk,
FA_ADDITIONS_B ad
WHERE ad.asset_id = X_asset_id
AND ad.asset_id = bk.asset_id
AND bk.book_type_code = X_book_type_code
and bk.transaction_header_id_out is null;
SELECT sum(nvl(deprn_adjustment_amount,0))
INTO h_deprn_adjustment_amount
FROM fa_deprn_detail_mrc_v
WHERE book_type_code = X_book_type_code
AND asset_id = X_asset_id
AND deprn_source_code = 'B';
SELECT sum(nvl(deprn_adjustment_amount,0))
INTO h_deprn_adjustment_amount
FROM fa_deprn_detail
WHERE book_type_code = X_book_type_code
AND asset_id = X_asset_id
AND deprn_source_code = 'B';
SELECT distribution_id, units_assigned
FROM fa_distribution_history
WHERE book_type_code = h_dist_book AND
asset_id = h_asset_id AND /* Bug 8237945 ... Since this is called only in Period of Addition,
and in Period of addition we always have to take
Distributions at the time of additions into consideration .*/
transaction_header_id_in = (SELECT TRANSACTION_HEADER_ID
FROM fa_transaction_headers
WHERE asset_id = h_asset_id
AND book_type_code = h_dist_book
AND transaction_type_code = 'TRANSFER IN')
-- date_ineffective IS NULL
ORDER BY distribution_id;
SELECT nvl(SUM(dh.units_assigned),0), COUNT(*)
INTO h_total_units, h_dist_count
FROM fa_distribution_history dh
WHERE dh.book_type_code = h_dist_book AND
dh.asset_id = h_asset_id AND
exists( SELECT 'X' FROM FA_TRANSACTION_HEADERS th
WHERE asset_id = h_asset_id and
book_type_code = h_dist_book and
dh.transaction_header_id_in = th.transaction_header_id and
th.transaction_type_code = 'TRANSFER IN');
DELETE FROM fa_deprn_detail_mrc_v
WHERE book_type_code = h_book_type_code AND
asset_id = h_asset_id AND
period_counter = h_period_counter;
DELETE FROM fa_deprn_detail
WHERE book_type_code = h_book_type_code AND
asset_id = h_asset_id AND
period_counter = h_period_counter;
IF (X_source_flag) THEN -- insert B row
h_source_code := 'B';
h_source_code := 'D'; -- insert D row
fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values before the insert to deprn_detail',''
,p_log_level_rec => p_log_level_rec);
INSERT INTO fa_deprn_detail_mrc_v
(BOOK_TYPE_CODE,
ASSET_ID,
DISTRIBUTION_ID,
PERIOD_COUNTER,
DEPRN_RUN_DATE,
DEPRN_AMOUNT,
YTD_DEPRN,
ADDITION_COST_TO_CLEAR,
DEPRN_RESERVE,
/* Bug 525654 Modification */
DEPRN_ADJUSTMENT_AMOUNT,
REVAL_RESERVE,
YTD_REVAL_DEPRN_EXPENSE,
COST,
DEPRN_SOURCE_CODE,
BONUS_DEPRN_AMOUNT,
BONUS_YTD_DEPRN,
BONUS_DEPRN_RESERVE)
VALUES (h_book_type_code,
h_asset_id,
h_dist_id,
h_period_counter,
h_sysdate,
0,
h_part_ytd,
decode(h_source_code, 'B',h_part_cost,0),
h_part_deprn_reserve,
/* Bug 525654 Modification */
h_part_deprn_adjustment_amount,
h_part_reval_reserve,
h_part_ytd_reval_dep_exp,
decode(h_source_code, 'D',h_part_cost,0),
h_source_code,
0,
h_part_bonus_ytd,
h_part_bonus_deprn_reserve);
INSERT INTO fa_deprn_detail(BOOK_TYPE_CODE,
ASSET_ID,
DISTRIBUTION_ID,
PERIOD_COUNTER,
DEPRN_RUN_DATE,
DEPRN_AMOUNT,
YTD_DEPRN,
ADDITION_COST_TO_CLEAR,
DEPRN_RESERVE,
/* Bug 525654 Modification */
DEPRN_ADJUSTMENT_AMOUNT,
REVAL_RESERVE,
YTD_REVAL_DEPRN_EXPENSE,
COST,
DEPRN_SOURCE_CODE,
BONUS_DEPRN_AMOUNT,
BONUS_YTD_DEPRN,
BONUS_DEPRN_RESERVE)
VALUES (h_book_type_code,
h_asset_id,
h_dist_id,
h_period_counter,
h_sysdate,
0,
h_part_ytd,
decode(h_source_code, 'B',h_part_cost,0),
h_part_deprn_reserve,
/* Bug 525654 Modification */
h_part_deprn_adjustment_amount,
h_part_reval_reserve,
h_part_ytd_reval_dep_exp,
decode(h_source_code, 'D',h_part_cost,0),
h_source_code,
0,
h_part_bonus_ytd,
h_part_bonus_deprn_reserve);