339: UNION ALL
340: SELECT '3'
341: FROM Okl_Pdt_Opts_V pon,
342: Okl_Pdt_Opt_Vals_V pov,
343: Okl_Opt_Values_V ove
344: WHERE pon.PDT_ID = p_pdt_id
345: AND pov.PON_ID = pon.ID
346: AND ove.ID = pov.OVE_ID
347: AND ((ove.FROM_DATE > p_from_date OR
3543: pov.FROM_DATE FROM_DATE,
3544: pov.TO_DATE TO_DATE
3545: FROM Okl_Pdt_Opts_V pon,
3546: Okl_Pdt_Opt_Vals_V pov,
3547: Okl_Opt_Values_V ove
3548: WHERE pon.PDT_ID = p_pdt_id
3549: AND pov.PON_ID = pon.ID
3550: AND ove.ID = pov.OVE_ID;
3551: