APPS.FA_ASSET_CALC_PVT dependencies on FA_MC_BOOKS

Line 1392: update fa_mc_books

1388: where asset_id = l_group_rcl_out_asset
1389: and book_type_code = p_asset_hdr_rec.book_type_code
1390: and transaction_header_id_out is null;
1391: else
1392: update fa_mc_books
1393: set adjustment_required_status = 'GADJ'
1394: where asset_id = l_group_rcl_out_asset
1395: and book_type_code = p_asset_hdr_rec.book_type_code
1396: and set_of_books_id = p_asset_hdr_rec.set_of_books_id

Line 3499: from fa_mc_books bk,

3495: and ad.asset_type = 'CAPITALIZED';
3496: else
3497: select nvl(sum(allowed_deprn_limit_amount), 0)
3498: into px_asset_fin_rec_new.allowed_deprn_limit_amount
3499: from fa_mc_books bk,
3500: fa_additions_b ad
3501: where bk.transaction_header_id_out is null
3502: and bk.group_asset_id = p_asset_hdr_rec.asset_id
3503: and bk.asset_id = ad.asset_id

Line 3833: from fa_mc_books bk,

3829: and ad.asset_type = 'CAPITALIZED';
3830: else
3831: select nvl(sum(salvage_value), 0)
3832: into px_asset_fin_rec_new.salvage_value
3833: from fa_mc_books bk,
3834: fa_additions_b ad
3835: where bk.transaction_header_id_out is null
3836: and bk.group_asset_id = p_asset_hdr_rec.asset_id
3837: and bk.asset_id = ad.asset_id