[Home] [Help]
1341: -- Get warranty_id since it's not in the view
1342: begin
1343: select warranty_id
1344: into px_asset_desc_rec.warranty_id
1345: from fa_add_warranties
1346: where asset_id = p_asset_hdr_rec.asset_id
1347: and date_ineffective is NULL;
1348: exception
1349: when no_data_found then