DBA Data[Home] [Help]

APPS.OKL_SETUPPRODUCTS_PVT dependencies on OKL_OPTIONS_V

Line 333: Okl_Options_V opt

329: NVL(qve.TO_DATE, p_to_date) < p_to_date)
330: UNION ALL
331: SELECT '2'
332: FROM Okl_Pdt_Opts_V pon,
333: Okl_Options_V opt
334: WHERE pon.PDT_ID = p_pdt_id
335: AND opt.ID = pon.OPT_ID
336: AND ((opt.FROM_DATE > p_from_date OR
337: p_from_date > NVL(opt.TO_DATE,p_from_date)) OR