APPS.FA_TRACK_MEMBER_PVT dependencies on FA_ADJUSTMENTS_MRC_V

Line 415: from fa_adjustments_mrc_v aj

411: -- ENERGY
412: cursor c_get_mc_adj(c_asset_id number) is
413: select nvl(sum(decode(aj.adjustment_type, 'RESERVE',decode(aj.debit_credit_flag, 'DR', -1, 1),
414: 'EXPENSE',decode(aj.debit_credit_flag, 'CR', -1, 1))* aj.adjustment_amount), 0)
415: from fa_adjustments_mrc_v aj
416: where aj.asset_id = c_asset_id
417: and aj.book_type_code = h_book_type_code
418: and aj.period_counter_created = h_period_counter
419: and aj.adjustment_type in ('RESERVE', 'EXPENSE');

Line 8633: from fa_adjustments_mrc_v adj

8629: sum(decode(adj.adjustment_type,'BONUS EXPENSE',
8630: decode(adj.debit_credit_flag,
8631: 'DR',adj.adjustment_amount,
8632: 'CR', -1 * adj.adjustment_amount)))
8633: from fa_adjustments_mrc_v adj
8634: where adj.asset_id = h_group_asset_id
8635: and adj.book_type_code = h_book_type_code
8636: and adj.period_counter_adjusted = p_period_counter;
8637:

Line 10446: from fa_adjustments_mrc_v adj

10442: cursor FA_ADJ_RESERVE_MRC is
10443: select sum(decode(adj.debit_credit_flag,
10444: 'DR',adj.adjustment_amount,
10445: 'CR', -1 * adj.adjustment_amount))
10446: from fa_adjustments_mrc_v adj
10447: where adj.book_type_code = h_book_type_code
10448: and adj.asset_id = h_member_asset_id
10449: and adj.adjustment_type = 'RESERVE'
10450: and nvl(adj.track_member_flag, 'N') = 'N' -- ENERGY