APPS.FA_ASSET_VAL_PVT dependencies on FA_ADDITIONS_B

Line 453: from fa_additions_b

449:
450: -- Asset number must be unique.
451: select count(*)
452: into l_count
453: from fa_additions_b
454: where asset_number = upper(p_asset_number);
455:
456: if (l_count > 0) then
457: fa_srvr_msg.add_message(

Line 2412: from fa_additions_b

2408:
2409: -- Make sure that tag_number does not already exist in fa_additions.
2410: select count(*)
2411: into l_tag_number_count
2412: from fa_additions_b
2413: where tag_number = p_tag_number;
2414:
2415: if (l_tag_number_count > 0) then
2416: fa_srvr_msg.add_message(

Line 5822: fa_additions_b ad

5818: cursor c_last_ret_mem_details is
5819: select ad.asset_id, ad.asset_number,
5820: ret.transaction_header_id_in
5821: from fa_retirements ret,
5822: fa_additions_b ad
5823: where ret.book_type_code = p_asset_retire_rec.detail_info.book_type_code
5824: and ad.asset_id = ret.asset_id
5825: and ret.transaction_header_id_in =
5826: (select max(far.transaction_header_id_in)

Line 5852: l_last_asset_id fa_additions_b.asset_id%type;

5848: l_ret_cost number;
5849: l_ret_salvage_value number;
5850: l_max_ret_adj_reverse number;
5851: l_max_ret_trx_id number;
5852: l_last_asset_id fa_additions_b.asset_id%type;
5853: l_last_asset_num fa_additions_b.asset_number%type;
5854: l_grp_cost fa_books.cost%type;
5855:
5856: val_err exception;

Line 5853: l_last_asset_num fa_additions_b.asset_number%type;

5849: l_ret_salvage_value number;
5850: l_max_ret_adj_reverse number;
5851: l_max_ret_trx_id number;
5852: l_last_asset_id fa_additions_b.asset_id%type;
5853: l_last_asset_num fa_additions_b.asset_number%type;
5854: l_grp_cost fa_books.cost%type;
5855:
5856: val_err exception;
5857:

Line 6233: from fa_additions_b

6229: select 1
6230: into l_count
6231: from dual
6232: where exists (select 'X'
6233: from fa_additions_b
6234: where asset_id = p_asset_id
6235: and asset_type = 'GROUP');
6236: exception
6237: when no_data_found then