DBA Data[Home] [Help]

APPS.EAM_CAP_MAIN_COST_PVT dependencies on FA_ADDITIONS_B

Line 66: FROM fa_additions_b fa

62: SELECT fa.asset_category_id,
63: fa.asset_number,
64: fa.in_use_flag,
65: fa.asset_type
66: FROM fa_additions_b fa
67: WHERE asset_id = pc_fixed_asset_id;
68:
69: r_fa_asset_number c_fa_asset_number%rowtype;
70:

Line 142: -- Get the FA Asset Number from FA_ADDITIONS_B

138: END IF ;
139: END IF;-- Added CU Project
140:
141: IF l_add_to_asset = TRUE then
142: -- Get the FA Asset Number from FA_ADDITIONS_B
143: OPEN c_fa_asset_number (l_fa_asset_id);
144: FETCH c_fa_asset_number INTO r_fa_asset_number;
145: IF c_fa_asset_number%FOUND THEN
146: l_asset_category_id := r_fa_asset_number.asset_category_id;