DBA Data[Home] [Help]

APPS.FA_IMPAIRMENT_DELETE_PVT dependencies on FA_ADJUSTMENTS

Line 244: delete from fa_adjustments

240: end if;
241:
242: if G_release = 11 then
243: FORALL i in 1..t_thid.count
244: delete from fa_adjustments
245: where transaction_header_id = t_thid(i)
246: and asset_id = t_asset_id(i)
247: and book_type_code = p_book_type_code
248: and period_counter_created = p_period_rec.period_counter;

Line 1049: l_adj_row_rec FA_ADJUSTMENTS%rowtype;

1045:
1046: l_adj fa_adjust_type_pkg.fa_adj_row_struct;
1047: l_clear_adj fa_adjust_type_pkg.fa_adj_row_struct;
1048:
1049: l_adj_row_rec FA_ADJUSTMENTS%rowtype;
1050: l_current_units number;
1051: l_thid number;
1052: l_login_id number(15) := fnd_global.user_id;
1053:

Line 1078: FROM fa_adjustments adj,

1074: adj.adjustment_amount ,
1075: adj.adjustment_type ,
1076: adj.source_type_code ,
1077: ad.current_units
1078: FROM fa_adjustments adj,
1079: fa_additions_b ad
1080: WHERE transaction_header_id = p_thid
1081: AND ad.asset_id = adj.asset_id;
1082:

Line 1173: delete from fa_adjustments

1169: and transaction_header_id_in = p_thid
1170: and book_type_code = p_book_type_code
1171: and asset_id = p_asset_id ;
1172:
1173: delete from fa_adjustments
1174: where transaction_header_id = p_thid
1175: and asset_id = p_asset_id
1176: and book_type_code = p_book_type_code
1177: and period_counter_created = l_period_rec.period_counter;