APPS.OKL_SETUPTQUALITYS_PVT dependencies on OKL_PTQ_VALUES_V

Line 89: FROM Okl_PTQ_VALUES_V ptv

85: CURSOR okl_ptvv_fk_csr (p_ptq_id IN Okl_Products_V.id%TYPE) IS
86: SELECT ptv.ID ID,
87: ptv.FROM_DATE FROM_DATE,
88: ptv.TO_DATE TO_DATE
89: FROM Okl_PTQ_VALUES_V ptv
90: WHERE ptv.ptq_id = p_ptq_id
91: AND ptv.TO_DATE IS NULL;
92:
93: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 146: FROM OKL_ptq_values_V ptv

142: p_from_date IN Okl_ptl_Qualitys_V.FROM_DATE%TYPE,
143: p_to_date IN Okl_ptl_Qualitys_V.TO_DATE%TYPE
144: ) IS
145: SELECT '1'
146: FROM OKL_ptq_values_V ptv
147: WHERE ptv.ptq_id = p_ptq_id
148: AND (ptv.FROM_DATE < p_from_date OR
149: NVL(ptv.TO_DATE, ptv.FROM_DATE) > p_to_date)
150: UNION ALL