select max(prod_id)
from product
where effdt = (select max(effdt) from product)