SELECT * FROM   data_owner.con_contact, data_owner.cxi_con_extended_info WHERE  con_code = cxi_con_code
AND    cxi_end_date  IS NULL
AND    cxi_cgrl_code IN ('SENDIR','EXECDIR','DIRECTOR')
AND    EXISTS (SELECT 1
               FROM   tech_params
               WHERE  param_name LIKE 'VWS_VAL_DEP_CODE%'
               AND    PARAM_VALUE = con_dep_code);