select l.currency from acs_objects o, acs_data_links r, iv_price_lists l, cr_items li where o.object_id = l.list_id and o.package_id = :package_id and l.list_id = li.latest_revision and r.object_id_one = li.item_id and r.object_id_two = :organization_id select l.currency from acs_objects o, iv_price_lists l, cr_items li where o.object_id = l.list_id and o.package_id = :package_id and l.list_id = li.latest_revision and not exists (select 1 from acs_data_links r, acs_objects o where r.object_id_one = li.item_id and r.object_id_two = o.object_id and o.object_type = 'organization') select li.item_id as list_id from acs_objects o, acs_data_links r, iv_price_lists l, cr_items li where o.object_id = l.list_id and o.package_id = :package_id and l.list_id = li.latest_revision and r.object_id_one = li.item_id and r.object_id_two = :organization_id select li.item_id as list_id from acs_objects o, iv_price_lists l, cr_items li where o.object_id = l.list_id and o.package_id = :package_id and l.list_id = li.latest_revision and not exists (select 1 from acs_data_links r, acs_objects o where r.object_id_one = li.item_id and r.object_id_two = o.object_id and o.object_type = 'organization') select min(li.item_id) as list_id from acs_objects o, iv_price_lists l, cr_items li where o.object_id = l.list_id and o.package_id = :package_id and l.list_id = li.latest_revision