APPS.FA_TRACK_MEMBER_PVT dependencies on FA_MC_ADJUSTMENTS

Line 726: from fa_mc_adjustments adj,

722: sum(decode(adj.adjustment_type,'BONUS EXPENSE',
723: decode(adj.debit_credit_flag,
724: 'DR',adj.adjustment_amount,
725: 'CR', -1 * adj.adjustment_amount)))
726: from fa_mc_adjustments adj,
727: fa_transaction_headers th1,
728: fa_transaction_headers th2
729: where adj.transaction_header_id = th1.transaction_header_id
730: and adj.asset_id = h_group_asset_id

Line 785: from fa_mc_adjustments adj,

781: select sum(decode(adj.adjustment_type,'EXPENSE',
782: decode(adj.debit_credit_flag,
783: 'DR',adj.adjustment_amount,
784: 'CR', -1 * adj.adjustment_amount)))
785: from fa_mc_adjustments adj,
786: fa_transaction_headers th1,
787: fa_transaction_headers th2
788: where adj.transaction_header_id = th1.transaction_header_id
789: and adj.asset_id = h_group_asset_id

Line 804: from fa_mc_adjustments adj,

800: select sum(decode(adj.adjustment_type,'EXPENSE',
801: decode(adj.debit_credit_flag,
802: 'DR',adj.adjustment_amount,
803: 'CR', -1 * adj.adjustment_amount)))
804: from fa_mc_adjustments adj,
805: fa_transaction_headers th
806: where adj.book_type_code = h_book_type_code
807: and adj.asset_id = h_member_asset_id
808: and adj.set_of_books_id = h_set_of_books_id

Line 3143: from fa_mc_adjustments adj,

3139: sum(decode(adj.adjustment_type,'BONUS EXPENSE',
3140: decode(adj.debit_credit_flag,
3141: 'DR',adj.adjustment_amount,
3142: 'CR', -1 * adj.adjustment_amount)))
3143: from fa_mc_adjustments adj,
3144: fa_transaction_headers th1,
3145: fa_transaction_headers th2
3146: where adj.transaction_header_id = th1.transaction_header_id
3147: and adj.asset_id = p_group_asset_id

Line 3940: from fa_mc_adjustments adj,

3936: sum(decode(adj.adjustment_type,'BONUS EXPENSE',
3937: decode(adj.debit_credit_flag,
3938: 'DR',adj.adjustment_amount,
3939: 'CR', -1 * adj.adjustment_amount)))
3940: from fa_mc_adjustments adj,
3941: fa_transaction_headers th1,
3942: fa_transaction_headers th2
3943: where adj.transaction_header_id = th1.transaction_header_id
3944: and adj.asset_id = h_group_asset_id

Line 3961: from fa_mc_adjustments adj

3957: sum(decode(adj.adjustment_type,'BONUS EXPENSE',
3958: decode(adj.debit_credit_flag,
3959: 'DR',adj.adjustment_amount,
3960: 'CR', -1 * adj.adjustment_amount)))
3961: from fa_mc_adjustments adj
3962: where adj.book_type_code = h_book_type_code
3963: and adj.asset_id = h_member_asset_id
3964: and adj.set_of_books_id = h_set_of_books_id
3965: and adj.period_counter_adjusted = h_period_counter;

Line 4117: from fa_mc_adjustments adj,

4113: nvl(sum(decode(adj.adjustment_type,'REMOVALCOST CLR',
4114: decode(adj.debit_credit_flag,
4115: 'CR',adj.adjustment_amount,
4116: 'DR', -1 * adj.adjustment_amount))),0)
4117: from fa_mc_adjustments adj,
4118: fa_transaction_headers th1,
4119: fa_transaction_headers th2
4120: where adj.transaction_header_id = th1.transaction_header_id
4121: and adj.asset_id = h_group_asset_id

Line 4147: from fa_mc_adjustments adj

4143: nvl(sum(decode(adj.adjustment_type,'REMOVALCOST CLR',
4144: decode(adj.debit_credit_flag,
4145: 'CR',adj.adjustment_amount,
4146: 'DR', -1 * adj.adjustment_amount))),0)
4147: from fa_mc_adjustments adj
4148: where adj.book_type_code = h_book_type_code
4149: and adj.asset_id = h_member_asset_id
4150: and adj.set_of_books_id = h_set_of_books_id
4151: and adj.period_counter_adjusted = h_period_counter

Line 6237: from fa_mc_adjustments adj

6233: cursor FA_ADJ_RESERVE_MRC is
6234: select sum(decode(adj.debit_credit_flag,
6235: 'DR',adj.adjustment_amount,
6236: 'CR', -1 * adj.adjustment_amount))
6237: from fa_mc_adjustments adj
6238: where adj.book_type_code = h_book_type_code
6239: and adj.asset_id = h_member_asset_id
6240: and adj.adjustment_type = 'RESERVE'
6241: and adj.source_type_code = 'ADJUSTMENT'