APPS.FA_CALC_DEPRN_BASIS2_PKG dependencies on FA_ADJUSTMENTS

Line 1352: from fa_adjustments adj

1348: 'RESERVE',
1349: decode(adj.debit_credit_flag,
1350: 'DR',adj.adjustment_amount,
1351: 'CR',-adj.adjustment_amount))),0) current_period_reserve
1352: from fa_adjustments adj
1353: where adj.asset_id = px_rule_in.asset_id
1354: and adj.book_type_code = px_rule_in.book_type_code
1355: and adj.period_counter_created = px_rule_in.period_counter
1356: ;

Line 1377: from fa_adjustments adj,

1373: 'RESERVE',
1374: decode(adj.debit_credit_flag,
1375: 'DR',adj.adjustment_amount,
1376: 'CR',-adj.adjustment_amount))),0) current_period_reserve
1377: from fa_adjustments adj,
1378: fa_transaction_headers th1,
1379: fa_transaction_headers th2
1380: where adj.asset_id = px_rule_in.asset_id
1381: and adj.book_type_code = px_rule_in.book_type_code

Line 1426: from fa_adjustments adj,

1422: 'EXPENSE',
1423: decode(adj.debit_credit_flag,
1424: 'DR',adj.adjustment_amount,
1425: 'CR',-adj.adjustment_amount))),0) current_period_expense
1426: from fa_adjustments adj,
1427: fa_transaction_headers th,
1428: fa_deprn_periods dp
1429: where adj.asset_id = px_rule_in.asset_id
1430: and adj.book_type_code = px_rule_in.book_type_code

Line 2931: from fa_adjustments adj

2927: cursor GET_DEPRN_EXP is
2928: select nvl(sum(decode(adj.debit_credit_flag,
2929: 'DR',adj.adjustment_amount,
2930: 'CR',-adj.adjustment_amount)),0) beginning_period_expense
2931: from fa_adjustments adj
2932: where adj.asset_id = px_rule_in.asset_id
2933: and adj.book_type_code = px_rule_in.book_type_code
2934: and adj.period_counter_created = px_rule_in.period_counter
2935: and adj.source_type_code ='DEPRECIATION'