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