APPS.FA_IMPAIRMENT_DELETE_PVT dependencies on FA_MC_ADJUSTMENTS

Line 139: delete from fa_mc_adjustments

135: end if;
136:
137: if G_release = 11 then
138: FORALL i in 1..t_thid.count
139: delete from fa_mc_adjustments
140: where transaction_header_id = t_thid(i)
141: and asset_id = t_asset_id(i)
142: and book_type_code = p_book_type_code
143: and period_counter_created = p_period_rec.period_counter

Line 1064: FROM fa_mc_adjustments adj,

1060: adj.adjustment_amount ,
1061: adj.adjustment_type ,
1062: adj.source_type_code ,
1063: ad.current_units
1064: FROM fa_mc_adjustments adj,
1065: fa_additions_b ad
1066: WHERE transaction_header_id = p_thid
1067: AND set_of_books_id = p_set_of_books_id
1068: AND ad.asset_id = adj.asset_id;

Line 1878: delete from fa_mc_adjustments

1874: and book_type_code = p_book_type_code
1875: and asset_id = p_asset_id
1876: and set_of_books_id = p_set_of_books_id;
1877:
1878: delete from fa_mc_adjustments
1879: where transaction_header_id = p_thid
1880: and asset_id = p_asset_id
1881: and book_type_code = p_book_type_code
1882: and period_counter_created = l_period_rec.period_counter