Query to Compare Varchar Date To Date

AND TO_DATE(P_EFFECTIVE_DATE,'DD-MON-YYYY')  BETWEEN TO_DATE(PIE.PEI_INFORMATION3,'YYYY/MM/DD HH24:MI:SS') AND NVL(TO_DATE(PIE.PEI_INFORMATION4,'YYYY/MM/DD HH24:MI:SS'),'31-DEC-4712');