APPS.OKL_SETUPPOVALUES_PVT dependencies on OKL_OPT_VALUES_V

Line 156: FROM Okl_Opt_Values_V ove

152: p_from_date IN Okl_Pdt_Qualitys_V.FROM_DATE%TYPE,
153: p_to_date IN Okl_Pdt_Qualitys_V.TO_DATE%TYPE
154: ) IS
155: SELECT '1'
156: FROM Okl_Opt_Values_V ove
157: WHERE ove.ID = p_ove_id
158: AND ((ove.FROM_DATE > p_from_date OR
159: p_from_date > NVL(ove.TO_DATE,p_from_date)) OR
160: NVL(ove.TO_DATE, p_to_date) < p_to_date);

Line 334: FROM OKL_OPT_VALUES_V

330: ) IS
331: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
332: CURSOR okl_pdt_opt_vals_foreign1 (p_foreign OKL_PDT_OPT_VALS.OVE_ID%TYPE) IS
333: SELECT ID
334: FROM OKL_OPT_VALUES_V
335: WHERE OKL_OPT_VALUES_V.ID = p_foreign;
336:
337: l_foreign_key OKL_PDT_OPT_VALS_V.OVE_ID%TYPE;
338: l_token_1 VARCHAR2(1999);

Line 335: WHERE OKL_OPT_VALUES_V.ID = p_foreign;

331: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
332: CURSOR okl_pdt_opt_vals_foreign1 (p_foreign OKL_PDT_OPT_VALS.OVE_ID%TYPE) IS
333: SELECT ID
334: FROM OKL_OPT_VALUES_V
335: WHERE OKL_OPT_VALUES_V.ID = p_foreign;
336:
337: l_foreign_key OKL_PDT_OPT_VALS_V.OVE_ID%TYPE;
338: l_token_1 VARCHAR2(1999);
339: