SELECT * FROM CI_CC_TYPE CT, CI_CC_TYPE_L CTL WHERE CT.CC_CL_CD = :INSERT_CONTACT_CLASS_HERE AND CT.CC_TYPE_CD = CTL.CC_TYPE_CD AND CTL.LANGUAGE_CD = :INSERT_LANGUAGE_HERE