APPS.EAM_CAP_MAIN_COST_PVT dependencies on FA_ADDITIONS_B

Line 55: FROM fa_additions_b fa

51: CURSOR c_fa_asset_number (pc_fixed_asset_id IN NUMBER) IS
52: SELECT fa.asset_category_id,
53: fa.asset_number,
54: fa.in_use_flag
55: FROM fa_additions_b fa
56: WHERE asset_id = pc_fixed_asset_id;
57:
58: r_fa_asset_number c_fa_asset_number%rowtype;
59:

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

126: END IF ;
127: END IF;-- Added CU Project
128:
129: IF l_add_to_asset = TRUE then
130: -- Get the FA Asset Number from FA_ADDITIONS_B
131: OPEN c_fa_asset_number (l_fa_asset_id);
132: FETCH c_fa_asset_number INTO r_fa_asset_number;
133: IF c_fa_asset_number%FOUND THEN
134: l_asset_category_id := r_fa_asset_number.asset_category_id;