APPS.OKL_SETUPPQUALITYS_PVT dependencies on OKL_PQY_VALUES_V

Line 84: CURSOR okl_qvev_fk_csr (p_qve_id IN Okl_pqy_values_V.id%TYPE) IS

80: x_return_status OUT NOCOPY VARCHAR2,
81: x_count OUT NOCOPY NUMBER,
82: x_qvev_tbl OUT NOCOPY qvev_tbl_type
83: ) IS
84: CURSOR okl_qvev_fk_csr (p_qve_id IN Okl_pqy_values_V.id%TYPE) IS
85: SELECT qve.ID ID,
86: qve.FROM_DATE FROM_DATE,
87: qve.TO_DATE TO_DATE
88: FROM Okl_Pqy_Values_V qve

Line 88: FROM Okl_Pqy_Values_V qve

84: CURSOR okl_qvev_fk_csr (p_qve_id IN Okl_pqy_values_V.id%TYPE) IS
85: SELECT qve.ID ID,
86: qve.FROM_DATE FROM_DATE,
87: qve.TO_DATE TO_DATE
88: FROM Okl_Pqy_Values_V qve
89: WHERE qve.pqy_id = p_qve_id
90: AND qve.TO_DATE IS NULL;
91:
92: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 145: FROM Okl_Pqy_Values_V qve

141: p_from_date IN Okl_Pdt_Qualitys_V.FROM_DATE%TYPE,
142: p_to_date IN Okl_Pdt_Qualitys_V.TO_DATE%TYPE
143: ) IS
144: SELECT '1'
145: FROM Okl_Pqy_Values_V qve
146: WHERE qve.pqy_id = p_pqy_id
147: AND (qve.FROM_DATE < p_from_date OR
148: NVL(qve.TO_DATE, qve.FROM_DATE) > p_to_date)
149: UNION ALL