APPS.FA_PROCESS_GROUPS_PKG dependencies on FA_BOOKS

Line 199: from fa_books bk,

195: th.calling_interface,
196: th.member_transaction_header_id,
197: th.trx_reference_id,
198: th.event_id
199: from fa_books bk,
200: fa_transaction_headers th
201: where bk.asset_id in (l_source_asset_id, l_dest_asset_id)
202: and bk.book_type_code = p_book
203: and bk.adjustment_required_status = 'GADJ'

Line 221: from fa_books bk,

217: th.calling_interface,
218: th.member_transaction_header_id,
219: th.trx_reference_id,
220: th.event_id
221: from fa_books bk,
222: fa_transaction_headers th
223: where bk.book_type_code = p_book
224: and bk.adjustment_required_status = 'GADJ'
225: and bk.date_ineffective is null

Line 231: from fa_books

227: order by bk.transaction_header_id_in;
228:
229: cursor get_old_trx is
230: select transaction_header_id_in
231: from fa_books
232: where asset_id = l_asset_id
233: and book_type_code = p_book
234: and transaction_header_id_out = l_trx_id_in;
235:

Line 238: from fa_books

234: and transaction_header_id_out = l_trx_id_in;
235:
236: cursor check_adj_status is
237: select count(*)
238: from fa_books
239: where transaction_header_id_in = l_trx_id_in
240: and adjustment_required_status = 'GADJ';
241:
242: --Bug#8675920

Line 989: -- now update fa_books

985: end if;
986:
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,

Line 1004: update fa_books

1000: where asset_id = l_asset_id
1001: and book_type_code = p_book
1002: and transaction_header_id_out is null;
1003: else
1004: update fa_books
1005: set rate_adjustment_factor =
1006: l_asset_fin_rec_new.rate_adjustment_factor,
1007: reval_amortization_basis =
1008: l_asset_fin_rec_new.reval_amortization_basis,

Line 1279: update fa_books

1275: where asset_id = l_asset_id
1276: and book_type_code = p_book
1277: and transaction_header_id_out is null;
1278: else
1279: update fa_books
1280: set adjustment_required_status = 'NONE'
1281: where rowid = l_rowid;
1282: end if;
1283: end if;

Line 1517: from fa_books

1513: and transaction_header_id_out is null;
1514:
1515: cursor get_old_trx is
1516: select transaction_header_id_in
1517: from fa_books
1518: where asset_id = l_asset_id
1519: and book_type_code = p_trx_ref_rec.book_type_code
1520: and transaction_header_id_out = l_trx_id_in;
1521:

Line 1878: update fa_books

1874:
1875: -- Release lock from member asset. No harm releasing for both books
1876: /* bug 10097181 */
1877: if (l_group_reclass_code = 'GRP-NONE' ) then
1878: update fa_books
1879: set adjustment_required_status = 'NONE'
1880: where asset_id = p_trx_ref_rec.member_asset_id
1881: and book_type_code = p_trx_ref_rec.book_type_code
1882: and adjustment_required_status = 'GADJ'

Line 2806: update fa_books

2802:
2803: if (l_sob_index = 0) then
2804:
2805: if (l_src_asset_type_rec.asset_type = 'GROUP') then
2806: update fa_books
2807: set adjustment_required_status = 'NONE'
2808: , adjusted_cost = l_grp_src_asset_fin_rec_new(l_sob_index).adjusted_cost
2809: , rate_adjustment_factor = l_grp_src_asset_fin_rec_new(l_sob_index).rate_adjustment_factor
2810: , formula_factor = l_grp_src_asset_fin_rec_new(l_sob_index).formula_factor

Line 2822: update fa_books

2818: where asset_id = l_src_asset
2819: and book_type_code = p_trx_ref_rec.book_type_code
2820: and transaction_header_id_out is null;
2821: else
2822: update fa_books
2823: set adjustment_required_status = 'NONE'
2824: where asset_id = l_src_asset
2825: and book_type_code = p_trx_ref_rec.book_type_code
2826: and transaction_header_id_out is null;

Line 2830: update fa_books

2826: and transaction_header_id_out is null;
2827: end if;
2828:
2829: if (l_dest_asset_type_rec.asset_type = 'GROUP') then
2830: update fa_books
2831: set adjustment_required_status = 'NONE'
2832: , adjusted_cost = l_grp_dest_asset_fin_rec_new(l_sob_index).adjusted_cost
2833: , rate_adjustment_factor = l_grp_dest_asset_fin_rec_new(l_sob_index).rate_adjustment_factor
2834: , formula_factor = l_grp_dest_asset_fin_rec_new(l_sob_index).formula_factor

Line 2846: update fa_books

2842: where asset_id = l_dest_asset
2843: and book_type_code = p_trx_ref_rec.book_type_code
2844: and transaction_header_id_out is null;
2845: else
2846: update fa_books
2847: set adjustment_required_status = 'NONE'
2848: where asset_id = l_dest_asset
2849: and book_type_code = p_trx_ref_rec.book_type_code
2850: and transaction_header_id_out is null;