select pkg_id, pretty_name from pb_packages where package_id = :package_id order by lower(pretty_name)