SELECT SP.* FROM CI_SP_GEO SPG, CI_SP SP WHERE SPG.SP_ID = SP.SP_ID AND SPG.GEO_TYPE_CD = 'INSERT_GEO_TYPE_CD' AND SPG.GEO_VAL = 'INSERT_GEO_VAL'