DBA Data[Home] [Help]

APPS.FA_ASSET_VAL_PVT dependencies on FA_ADDITIONS_B

Line 280: from fa_additions_b

276:
277: -- Asset number must be unique.
278: select count(*)
279: into l_count
280: from fa_additions_b
281: where asset_number = upper(p_asset_number);
282:
283: if (l_count > 0) then
284: fa_srvr_msg.add_message(

Line 2215: from fa_additions_b

2211:
2212: -- Make sure that tag_number does not already exist in fa_additions.
2213: select count(*)
2214: into l_tag_number_count
2215: from fa_additions_b
2216: where tag_number = p_tag_number;
2217:
2218: if (l_tag_number_count > 0) then
2219: fa_srvr_msg.add_message(

Line 2840: from fa_additions_b

2836: CURSOR get_cat_type IS
2837: select category_type
2838: from fa_categories_b
2839: where category_id = ( select asset_category_id
2840: from fa_additions_b
2841: where asset_id = p_asset_id );
2842: CURSOR C1 IS
2843: select currency_code
2844: from gl_sets_of_books sob,