CURSOR lcur_shipment_noorder(p_archive_trans_order_shipment NUMBER) IS
      SELECT archive_obj_id_type(shipment_id),
             archive_obj_id_type(to_contact_info_id),
             archive_obj_id_type(from_contact_info_id),
             archive_obj_id_type(NULL)
        FROM shipment sh, stg_archive.yfs_ship_tmp yfs
       WHERE trim(sh.orig_shipment_id)=trim(yfs.shipment_no)
       AND sh.shipment_id NOT IN (SELECT shipment_id
                                   FROM shipment_line
                                  WHERE order_line_id IN (SELECT id
                                                            FROM order_line
                                                         )
                                )
         AND shipment_status_id IN (SHIPMENT_DELIVERED, SHIPMENT_CANCELLED);

for pnt in (select col1,col2,col3
            from my_table1
            union all
            select cola,colb,colc
            from my_other_table) loop