SQL & PL/SQL

Select WIP_ENTITY_NAME,

WIP_DISCRETE_JOBS_V.CREATION_DATE CCC,

decode(STATUS_TYPE,3,'Released',1,'Unreleased',4,'Complete',12,'Closed'),

CONCATENATED_SEGMENTS,

from WIP_DISCRETE_JOBS_V,WIP_REQUIREMENT_OPERATIONS_V

Where

WIP_DISCRETE_JOBS_V.WIP_ENTITY_NAME like NVL('%'||:WIP_Name,WIP_ENTITY_NAME||'%')

OR

(   WIP_DISCRETE_JOBS_V.WIP_ENTITY_NAME BETWEEN NVL( :WIP_FROM,WIP_ENTITY_NAME) AND NVL(:WIP_TO,WIP_ENTITY_NAME)

AND WIP_DISCRETE_JOBS_V.CREATION_DATE >= any (select WIP_DISCRETE_JOBS_V.CREATION_DATE from WIP_DISCRETE_JOBS_V where WIP_DISCRETE_JOBS_V.WIP_ENTITY_NAME=(:WIP_FROM))   )

AND WIP_DISCRETE_JOBS_V.WIP_ENTITY_ID=WIP_REQUIREMENT_OPERATIONS_V.WIP_ENTITY_ID;

when i enter the WIP_FROM it work fine and when i enter WIP_FROM and WIP_Name it work fine too

but when i enter the WIP_Name only, it does not return any

why it is not working

any idea