APPS.FA_ASSET_CALC_PVT dependencies on FA_MC_ADJUSTMENTS

Line 1581: FROM fa_mc_adjustments adj,

1577: SELECT sum(decode(adj.debit_credit_flag,'DR',
1578: -1 * adj.adjustment_amount,
1579: adj.adjustment_amount))
1580: INTO l_deprn_exp_temp
1581: FROM fa_mc_adjustments adj,
1582: fa_transaction_headers th
1583: WHERE th.book_type_code = p_asset_hdr_rec.book_type_code
1584: and th.asset_id = p_asset_hdr_rec.asset_id
1585: and th.transaction_type_code in ('ADDITION', 'ADJUSTMENT') ----Bug7409454

Line 1684: FROM fa_mc_adjustments adj,

1680: sum(decode(adj.debit_credit_flag,'DR',
1681: -1 * adj.annualized_adjustment,
1682: adj.annualized_adjustment))
1683: INTO l_deprn_exp,l_ann_adj_deprn_exp
1684: FROM fa_mc_adjustments adj,
1685: fa_transaction_headers th
1686: WHERE th.book_type_code = p_asset_hdr_rec.book_type_code
1687: and th.asset_id = p_asset_hdr_rec.asset_id
1688: and th.transaction_type_code in ('ADDITION', 'ADJUSTMENT') ----Bug7409454

Line 1772: FROM fa_mc_adjustments adj,

1768: sum(decode(adj.debit_credit_flag,'DR',
1769: -1 * adj.annualized_adjustment,
1770: adj.annualized_adjustment))
1771: INTO l_deprn_exp,l_ann_adj_deprn_exp
1772: FROM fa_mc_adjustments adj,
1773: fa_transaction_headers th
1774: WHERE th.book_type_code = p_asset_hdr_rec.book_type_code
1775: and th.asset_id = p_asset_hdr_rec.asset_id
1776: and th.transaction_type_code in ('ADDITION', 'ADJUSTMENT')

Line 2192: from fa_mc_adjustments

2188: select nvl(sum(decode(debit_credit_flag,
2189: 'CR', adjustment_amount,
2190: adjustment_amount * -1)), 0)
2191: into l_clearing
2192: from fa_mc_adjustments
2193: where asset_id = p_asset_hdr_rec.asset_id
2194: and book_type_code = p_asset_hdr_rec.book_type_code
2195: and period_counter_created = p_period_rec.period_counter
2196: and transaction_header_id = px_trans_rec.transaction_header_id