select
r.object_id_one as emp_id
from
acs_rels r
where
r.object_id_two = :customer_id
and rel_type = 'contact_rels_employment'
select
user_id,
first_names ||' '|| last_name as fullname
from
cc_users
order by
last_name asc
select
group_id,
group_name
from
groups
order by
group_name asc
select
item_id as project_item_id
from
cr_items
where
content_type = 'pm_project'
select
cct.*,
cr.title,
cr.description
from
contact_complaint_track cct,
cr_revisions cr
where
complaint_id = :complaint_id
and revision_id = :complaint_id