2078: CURSOR c_get_adj_amount (c_transaction_header_id number
2079: , c_source_type_code varchar2
2080: , c_adjustment_type varchar2) IS
2081: SELECT sum(decode(debit_credit_flag, 'CR', -1, 1) * adjustment_amount)
2082: FROM fa_adjustments
2083: WHERE transaction_header_id = c_transaction_header_id
2084: AND asset_id = p_asset_id
2085: AND book_type_code = p_book_type_code
2086: AND source_type_code = c_source_type_code
2445: end if; -- (l_process_this_trx)
2446: END LOOP; -- i in 1..tt_transaction_header_id.count
2447:
2448: --
2449: -- Get reserve entry from fa_adjustments and fa_deprn_summary(b row)
2450: --
2451:
2452: l_asset_hdr_rec.asset_id := p_asset_id;
2453: l_asset_hdr_rec.period_of_addition := null;
3516: fa_debug_pkg.add(l_calling_fn,'Rec returned from c_get_bst', fa_amort_pvt.t_period_counter.count, p_log_level_rec => p_log_level_rec);
3517: end if;
3518:
3519: --
3520: -- Get reserve entry from fa_adjustments and fa_deprn_summary(b row)
3521: --
3522:
3523: l_asset_hdr_rec.asset_id := t_asset_id(j);
3524: l_asset_hdr_rec.period_of_addition := null;