APPS.FA_PROCESS_GROUPS_PKG dependencies on FA_MC_BOOKS

Line 245: from fa_mc_books

241:
242: --Bug#8675920
243: cursor check_mc_adj_status is
244: select count(*)
245: from fa_mc_books
246: where transaction_header_id_in = l_trx_id_in
247: and set_of_books_id = l_asset_hdr_rec.set_of_books_id
248: and adjustment_required_status = 'GADJ';
249:

Line 991: update fa_mc_books

987: end if;
988:
989: -- now update fa_books
990: if (l_mrc_sob_type_code = 'R') then
991: update fa_mc_books
992: set rate_adjustment_factor =
993: l_asset_fin_rec_new.rate_adjustment_factor,
994: reval_amortization_basis =
995: l_asset_fin_rec_new.reval_amortization_basis,

Line 1273: update fa_mc_books

1269:
1270: if (l_trans_rec.transaction_key in ('UA', 'UE', 'MR', 'MS')) then
1271:
1272: if(l_mrc_sob_type_code = 'R') then
1273: update fa_mc_books
1274: set adjustment_required_status = 'NONE'
1275: where asset_id = l_asset_id
1276: and book_type_code = p_book
1277: and transaction_header_id_out is null;

Line 1885: update fa_mc_books

1881: and book_type_code = p_trx_ref_rec.book_type_code
1882: and adjustment_required_status = 'GADJ'
1883: and transaction_header_id_out is null;
1884: if l_sob_tbl.count > 0 then
1885: update fa_mc_books
1886: set adjustment_required_status = 'NONE'
1887: where asset_id = p_trx_ref_rec.member_asset_id
1888: and book_type_code = p_trx_ref_rec.book_type_code
1889: and adjustment_required_status = 'GADJ'

Line 2861: update fa_mc_books

2857: where trx_reference_id = l_src_trans_rec.trx_reference_id;
2858:
2859: else
2860: if (l_src_asset_type_rec.asset_type = 'GROUP') then
2861: update fa_mc_books
2862: set adjustment_required_status = 'NONE'
2863: , adjusted_cost = l_grp_src_asset_fin_rec_new(l_sob_index).adjusted_cost
2864: , rate_adjustment_factor = l_grp_src_asset_fin_rec_new(l_sob_index).rate_adjustment_factor
2865: , formula_factor = l_grp_src_asset_fin_rec_new(l_sob_index).formula_factor

Line 2878: update fa_mc_books

2874: and book_type_code = p_trx_ref_rec.book_type_code
2875: and transaction_header_id_out is null
2876: and set_of_books_id = l_sob_tbl(l_sob_index);
2877: else
2878: update fa_mc_books
2879: set adjustment_required_status = 'NONE'
2880: where asset_id = l_src_asset
2881: and book_type_code = p_trx_ref_rec.book_type_code
2882: and transaction_header_id_out is null

Line 2887: update fa_mc_books

2883: and set_of_books_id = l_sob_tbl(l_sob_index);
2884: end if;
2885:
2886: if (l_dest_asset_type_rec.asset_type = 'GROUP') then
2887: update fa_mc_books
2888: set adjustment_required_status = 'NONE'
2889: , adjusted_cost = l_grp_dest_asset_fin_rec_new(l_sob_index).adjusted_cost
2890: , rate_adjustment_factor = l_grp_dest_asset_fin_rec_new(l_sob_index).rate_adjustment_factor
2891: , formula_factor = l_grp_dest_asset_fin_rec_new(l_sob_index).formula_factor

Line 2904: update fa_mc_books

2900: and book_type_code = p_trx_ref_rec.book_type_code
2901: and transaction_header_id_out is null
2902: and set_of_books_id = l_sob_tbl(l_sob_index);
2903: else
2904: update fa_mc_books
2905: set adjustment_required_status = 'NONE'
2906: where asset_id = l_dest_asset
2907: and book_type_code = p_trx_ref_rec.book_type_code
2908: and transaction_header_id_out is null