APPS.OKL_SETUPOPTIONS_PVT dependencies on OKL_OPT_VALUES_V

Line 113: CURSOR okl_ovev_fk_csr (p_opt_id IN Okl_opt_values_V.id%TYPE) IS

109: x_return_status OUT NOCOPY VARCHAR2,
110: x_count OUT NOCOPY NUMBER,
111: x_ovev_tbl OUT NOCOPY ovev_tbl_type
112: ) IS
113: CURSOR okl_ovev_fk_csr (p_opt_id IN Okl_opt_values_V.id%TYPE) IS
114: SELECT ove.ID ID,
115: ove.FROM_DATE FROM_DATE,
116: ove.TO_DATE TO_DATE
117: FROM Okl_opt_Values_V ove

Line 117: FROM Okl_opt_Values_V ove

113: CURSOR okl_ovev_fk_csr (p_opt_id IN Okl_opt_values_V.id%TYPE) IS
114: SELECT ove.ID ID,
115: ove.FROM_DATE FROM_DATE,
116: ove.TO_DATE TO_DATE
117: FROM Okl_opt_Values_V ove
118: WHERE ove.opt_id = p_opt_id
119: AND ove.TO_DATE IS NULL;
120:
121: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 196: FROM Okl_Opt_Values_V ove

192: p_to_date IN Okl_Options_V.TO_DATE%TYPE
193:
194: ) IS
195: SELECT '1'
196: FROM Okl_Opt_Values_V ove
197: WHERE ove.OPT_ID = p_opt_id
198: AND (ove.FROM_DATE < p_from_date OR
199: NVL(ove.TO_DATE, ove.FROM_DATE) > p_to_date);
200: