select 
xcid_id XCMS_ID
 from xcid 
 where xcid_birthtime is not null
 and
 to_date(decode(to_char(xcid_birthtime,'DD.MM'),'29.02','28.02',to_char(xcid_birthtime,'DD.MM'))||'.'||to_char(:BIRTH_FROM,'YYYY'),'DD.MM.YYYY') between to_date(to_char(:BIRTH_FROM,'DD.MM.YYYY'),'DD.MM.YYYY') and to_date(to_char(:BIRTH_TO,'DD.MM.YYYY'),'DD.MM.YYYY')
 and round((to_date(to_char(decode(to_char(xcid_birthtime,'DD.MM'),'29.02','28.02',to_char(xcid_birthtime,'DD.MM')))||'.'||to_char((select sysdate from dual),'YYYY'),'DD.MM.YYYY')-XCID_BIRTHTIME)/365)=:PARA_AGE