Types of treaties:
a)  self-executing treaties do not need any further Congressional
work to be a valid treaty
b)  non self-executing treaties need Congress to pass a statute to
give the treaty effect (all treaties that require appropriations are,
thus, non-self-ex)
c)  supremacy:  treaties are on par with federal statutes; if a
treaty conflicts with a statute, try to reconcile them; if you can’t,
the latter in time wins.