363: select asset_type,
364: current_units
365: into l_from_asset_type,
366: l_from_current_units
367: from fa_additions_b
368: where asset_id = px_src_asset_hdr_rec.asset_id;
369:
370: select asset_type,
371: current_units
370: select asset_type,
371: current_units
372: into l_to_asset_type,
373: l_to_current_units
374: from fa_additions_b
375: where asset_id = px_dest_asset_hdr_rec.asset_id;
376:
377:
378: l_src_asset_type_rec.asset_type := l_from_asset_type;
1090: end if;
1091:
1092: select asset_type,current_units
1093: into l_from_asset_type,l_from_current_units
1094: from fa_additions_b
1095: where asset_id = l_src_asset_hdr_rec.asset_id;
1096:
1097: select asset_type,current_units
1098: into l_to_asset_type,l_to_current_units
1095: where asset_id = l_src_asset_hdr_rec.asset_id;
1096:
1097: select asset_type,current_units
1098: into l_to_asset_type,l_to_current_units
1099: from fa_additions_b
1100: where asset_id = l_dest_asset_hdr_rec.asset_id;
1101:
1102: if ((l_dest_asset_hdr_rec.period_of_addition = 'N' and
1103: l_src_asset_hdr_rec.period_of_addition = 'N' and