select first_names, last_name, user_id as p_user_id
from cc_users where email = ''
select first_names, last_name, user_id as p_user_id
from cc_users where user_id <> :user_id
and (lower(first_names) like '%$user_name%'
or lower(last_name) like '%$user_name%') and user_id in (
select grantee_id from acs_permissions where privilege = 'create' and
object_id = :cc_package_id
) order by first_names, last_name
select first_names, last_name, user_id as p_user_id
from cc_users where user_id <> :user_id
and lower(email) like '%$user_email%' and user_id in (
select grantee_id from acs_permissions where privilege = 'create' and
object_id = :cc_package_id
) order by email
select first_names, last_name, user_id as p_user_id
from cc_users where user_id <> :user_id
lower(first_names) like '%$user_name%' or lower(last_name) like '%$user_name%')
and lower(email) like '%$user_email%' and user_id in (
select grantee_id from acs_permissions where privilege = 'create' and
object_id = :cc_package_id
) order by email