APPS.FA_CALC_DEPRN_BASIS2_PKG dependencies on FA_ADJUSTMENTS_MRC_V

Line 1186: from fa_adjustments_mrc_v adj

1182: 'RESERVE',
1183: decode(adj.debit_credit_flag,
1184: 'DR',adj.adjustment_amount,
1185: 'CR',-adj.adjustment_amount))),0) current_period_reserve
1186: from fa_adjustments_mrc_v adj
1187: where adj.asset_id = px_rule_in.asset_id
1188: and adj.book_type_code = px_rule_in.book_type_code
1189: and adj.period_counter_created = px_rule_in.period_counter
1190: ;

Line 1222: from fa_adjustments_mrc_v adj,

1218: 'RESERVE',
1219: decode(adj.debit_credit_flag,
1220: 'DR',adj.adjustment_amount,
1221: 'CR',-adj.adjustment_amount))),0) current_period_reserve
1222: from fa_adjustments_mrc_v adj,
1223: fa_transaction_headers th1,
1224: fa_transaction_headers th2
1225: where adj.asset_id = px_rule_in.asset_id
1226: and adj.book_type_code = px_rule_in.book_type_code

Line 1264: from fa_adjustments_mrc_v adj,

1260: 'EXPENSE',
1261: decode(adj.debit_credit_flag,
1262: 'DR',adj.adjustment_amount,
1263: 'CR',-adj.adjustment_amount))),0) current_period_expense
1264: from fa_adjustments_mrc_v adj,
1265: fa_transaction_headers th,
1266: fa_deprn_periods_mrc_v dp
1267: where adj.asset_id = px_rule_in.asset_id
1268: and adj.book_type_code = px_rule_in.book_type_code

Line 2713: from fa_adjustments_mrc_v adj

2709: cursor GET_DEPRN_EXP_M is
2710: select nvl(sum(decode(adj.debit_credit_flag,
2711: 'DR',adj.adjustment_amount,
2712: 'CR',-adj.adjustment_amount)),0) beginning_period_expense
2713: from fa_adjustments_mrc_v adj
2714: where adj.asset_id = px_rule_in.asset_id
2715: and adj.book_type_code = px_rule_in.book_type_code
2716: and adj.period_counter_created = px_rule_in.period_counter
2717: and adj.source_type_code ='DEPRECIATION'