DBA Data[Home] [Help]

APPS.OKL_SETUPTQUALITYS_PVT dependencies on OKL_PTL_PTQ_VALS_V

Line 152: FROM OKL_ptl_ptq_vals_V pmv

148: AND (ptv.FROM_DATE < p_from_date OR
149: NVL(ptv.TO_DATE, ptv.FROM_DATE) > p_to_date)
150: UNION ALL
151: SELECT '2'
152: FROM OKL_ptl_ptq_vals_V pmv
153: WHERE pmv.ptq_id = p_ptq_id
154: AND (pmv.FROM_DATE < p_from_date OR
155: NVL(pmv.TO_DATE, pmv.FROM_DATE) > p_to_date);
156: