select FLOOR(LOCAL_ID/1000) from T_SERVICE WHERE STATE_FLG = 0 AND DEL_FLG = 0 AND FLOOR(LOCAL_ID/1000)=${prm_pref_id}