select list_id, price_id, cost_id, offer_id, offer_item_id, offer_item_title_id,
invoice_id, invoice_item_id, payment_id
from iv_default_objects
where package_id = :package_id
insert into iv_default_objects
(package_id, list_id, price_id, cost_id, offer_id, offer_item_title_id,
offer_item_id, invoice_id, invoice_item_id, payment_id)
values
(:package_id, :list_id, :price_id, :cost_id, :offer_id, :offer_item_title_id,
:offer_item_id, :invoice_id, :invoice_item_id, :payment_id)
select u.password as user_password, u.salt as user_salt
from users u, acs_objects o
where u.user_id = o.creation_user
and o.object_id = :offer_id