DBA Data[Home] [Help]

APPS.FA_CALC_DEPRN_BASIS2_PKG dependencies on FA_MC_ADJUSTMENTS

Line 1364: from fa_mc_adjustments adj

1360: 'RESERVE',
1361: decode(adj.debit_credit_flag,
1362: 'DR',adj.adjustment_amount,
1363: 'CR',-adj.adjustment_amount))),0) current_period_reserve
1364: from fa_mc_adjustments adj
1365: where adj.asset_id = px_rule_in.asset_id
1366: and adj.book_type_code = px_rule_in.book_type_code
1367: and adj.period_counter_created = px_rule_in.period_counter
1368: and adj.set_of_books_id = px_rule_in.set_of_books_id;

Line 1400: from fa_mc_adjustments adj,

1396: 'RESERVE',
1397: decode(adj.debit_credit_flag,
1398: 'DR',adj.adjustment_amount,
1399: 'CR',-adj.adjustment_amount))),0) current_period_reserve
1400: from fa_mc_adjustments adj,
1401: fa_transaction_headers th1,
1402: fa_transaction_headers th2
1403: where adj.asset_id = px_rule_in.asset_id
1404: and adj.book_type_code = px_rule_in.book_type_code

Line 1444: from fa_mc_adjustments adj,

1440: 'EXPENSE',
1441: decode(adj.debit_credit_flag,
1442: 'DR',adj.adjustment_amount,
1443: 'CR',-adj.adjustment_amount))),0) current_period_expense
1444: from fa_mc_adjustments adj,
1445: fa_transaction_headers th,
1446: fa_mc_deprn_periods dp
1447: where adj.asset_id = px_rule_in.asset_id
1448: and adj.book_type_code = px_rule_in.book_type_code

Line 2942: from fa_mc_adjustments adj

2938: cursor GET_DEPRN_EXP_M is
2939: select nvl(sum(decode(adj.debit_credit_flag,
2940: 'DR',adj.adjustment_amount,
2941: 'CR',-adj.adjustment_amount)),0) beginning_period_expense
2942: from fa_mc_adjustments adj
2943: where adj.asset_id = px_rule_in.asset_id
2944: and adj.book_type_code = px_rule_in.book_type_code
2945: and adj.period_counter_created = px_rule_in.period_counter
2946: and adj.source_type_code ='DEPRECIATION'