select issue_type from ec_cs_issue_type_map where issue_id=:issue_id select first_names || ' ' || last_name from cc_users where user_id=:customer_service_rep