APPS.FA_ASSET_CALC_PVT dependencies on FA_ADJUSTMENTS

Line 1563: FROM fa_adjustments adj,

1559: SELECT sum(decode(adj.debit_credit_flag,'DR',
1560: -1 * adj.adjustment_amount,
1561: adj.adjustment_amount))
1562: INTO l_deprn_exp_temp
1563: FROM fa_adjustments adj,
1564: fa_transaction_headers th
1565: WHERE th.book_type_code = p_asset_hdr_rec.book_type_code
1566: and th.asset_id = p_asset_hdr_rec.asset_id
1567: and th.transaction_type_code in ('ADDITION', 'ADJUSTMENT') --Bug7409454

Line 1663: FROM fa_adjustments adj,

1659: sum(decode(adj.debit_credit_flag,'DR',
1660: -1 * adj.annualized_adjustment,
1661: adj.annualized_adjustment))
1662: INTO l_deprn_exp,l_ann_adj_deprn_exp
1663: FROM fa_adjustments adj,
1664: fa_transaction_headers th
1665: WHERE th.book_type_code = p_asset_hdr_rec.book_type_code
1666: and th.asset_id = p_asset_hdr_rec.asset_id
1667: and th.transaction_type_code in ('ADDITION', 'ADJUSTMENT') --Bug7409454

Line 1751: FROM fa_adjustments adj,

1747: sum(decode(adj.debit_credit_flag,'DR',
1748: -1 * adj.annualized_adjustment,
1749: adj.annualized_adjustment))
1750: INTO l_deprn_exp,l_ann_adj_deprn_exp
1751: FROM fa_adjustments adj,
1752: fa_transaction_headers th
1753: WHERE th.book_type_code = p_asset_hdr_rec.book_type_code
1754: and th.asset_id = p_asset_hdr_rec.asset_id
1755: and th.transaction_type_code in ('ADDITION', 'ADJUSTMENT')

Line 2181: from fa_adjustments

2177: select nvl(sum(decode(debit_credit_flag,
2178: 'CR', adjustment_amount,
2179: adjustment_amount * -1)), 0)
2180: into l_clearing
2181: from fa_adjustments
2182: where asset_id = p_asset_hdr_rec.asset_id
2183: and book_type_code = p_asset_hdr_rec.book_type_code
2184: and period_counter_created = p_period_rec.period_counter
2185: and transaction_header_id = px_trans_rec.transaction_header_id

Line 2374: -- Dupulicate group FA_ADJUSTMENTS entries on member asset

2370: end if;
2371: end if; --no change to disabled_flag
2372:
2373: -- ENERGY and allocate in general
2374: -- Dupulicate group FA_ADJUSTMENTS entries on member asset
2375: --
2376: if (p_log_level_rec.statement_level) then
2377: fa_debug_pkg.add(l_calling_fn, 'l_deprn_exp', l_deprn_exp, p_log_level_rec => p_log_level_rec);
2378: fa_debug_pkg.add(l_calling_fn, 'l_bonus_deprn_exp', l_bonus_deprn_exp, p_log_level_rec => p_log_level_rec);