APPS.FA_ASSET_CALC_PVT dependencies on FA_ADJUSTMENTS

Line 1260: FROM fa_adjustments adj,

1256: SELECT sum(decode(adj.debit_credit_flag,'DR',
1257: -1 * adj.adjustment_amount,
1258: adj.adjustment_amount))
1259: INTO l_deprn_exp
1260: FROM fa_adjustments adj,
1261: fa_transaction_headers th
1262: WHERE th.book_type_code = p_asset_hdr_rec.book_type_code
1263: and th.asset_id = p_asset_hdr_rec.asset_id
1264: and th.transaction_type_code in ('ADDITION', 'ADJUSTMENT') --Bug7409454

Line 1278: FROM fa_adjustments_mrc_v adj,

1274: SELECT sum(decode(adj.debit_credit_flag,'DR',
1275: -1 * adj.adjustment_amount,
1276: adj.adjustment_amount))
1277: INTO l_deprn_exp
1278: FROM fa_adjustments_mrc_v adj,
1279: fa_transaction_headers th
1280: WHERE th.book_type_code = p_asset_hdr_rec.book_type_code
1281: and th.asset_id = p_asset_hdr_rec.asset_id
1282: and th.transaction_type_code in ('ADDITION', 'ADJUSTMENT') ----Bug7409454

Line 1314: FROM fa_adjustments adj,

1310: SELECT sum(decode(adj.debit_credit_flag,'DR',
1311: -1 * adj.adjustment_amount,
1312: adj.adjustment_amount))
1313: INTO l_deprn_exp
1314: FROM fa_adjustments adj,
1315: fa_transaction_headers th
1316: WHERE th.book_type_code = p_asset_hdr_rec.book_type_code
1317: and th.asset_id = p_asset_hdr_rec.asset_id
1318: and th.transaction_type_code in ('ADDITION', 'ADJUSTMENT')

Line 1332: FROM fa_adjustments_mrc_v adj,

1328: SELECT sum(decode(adj.debit_credit_flag,'DR',
1329: -1 * adj.adjustment_amount,
1330: adj.adjustment_amount))
1331: INTO l_deprn_exp
1332: FROM fa_adjustments_mrc_v adj,
1333: fa_transaction_headers th
1334: WHERE th.book_type_code = p_asset_hdr_rec.book_type_code
1335: and th.asset_id = p_asset_hdr_rec.asset_id
1336: and th.transaction_type_code in ('ADDITION', 'ADJUSTMENT')

Line 1665: from fa_adjustments

1661: select nvl(sum(decode(debit_credit_flag,
1662: 'CR', adjustment_amount,
1663: adjustment_amount * -1)), 0)
1664: into l_clearing
1665: from fa_adjustments
1666: where asset_id = p_asset_hdr_rec.asset_id
1667: and book_type_code = p_asset_hdr_rec.book_type_code
1668: and period_counter_created = p_period_rec.period_counter
1669: and transaction_header_id = px_trans_rec.transaction_header_id

Line 1676: from fa_adjustments_mrc_v

1672: select nvl(sum(decode(debit_credit_flag,
1673: 'CR', adjustment_amount,
1674: adjustment_amount * -1)), 0)
1675: into l_clearing
1676: from fa_adjustments_mrc_v
1677: where asset_id = p_asset_hdr_rec.asset_id
1678: and book_type_code = p_asset_hdr_rec.book_type_code
1679: and period_counter_created = p_period_rec.period_counter
1680: and transaction_header_id = px_trans_rec.transaction_header_id

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

1754: end if;
1755: end if; --no change to disabled_flag
1756:
1757: -- ENERGY and allocate in general
1758: -- Dupulicate group FA_ADJUSTMENTS entries on member asset
1759: --
1760: if (p_log_level_rec.statement_level) then
1761: fa_debug_pkg.add(l_calling_fn, 'l_deprn_exp', l_deprn_exp);
1762: fa_debug_pkg.add(l_calling_fn, 'l_bonus_deprn_exp', l_bonus_deprn_exp);