[Home] [Help]
251: NVL(ptv.TO_DATE, p_to_date) < p_to_date)
252: UNION ALL
253: SELECT '2'
254: FROM Okl_Pdt_Pqys_V pdq,
255: Okl_Pdt_Qualitys_V pqy
256: WHERE pdq.PTL_ID = p_ptl_id
257: AND pqy.ID = pdq.PQY_ID
258: AND ((pqy.FROM_DATE > p_from_date OR
259: p_from_date > NVL(pqy.TO_DATE,p_from_date)) OR