APPS.OKL_SETUPOPTVALUES_PVT dependencies on OKL_OPTIONS_V

Line 240: FROM Okl_Options_V opt

236: ) IS
237: CURSOR okl_optv_pk_csr (p_opt_id IN NUMBER) IS
238: SELECT FROM_DATE,
239: TO_DATE
240: FROM Okl_Options_V opt
241: WHERE opt.id = p_opt_id;
242: l_okl_optv_pk okl_optv_pk_csr%ROWTYPE;
243: l_optv_rec optv_rec_type;
244: BEGIN

Line 284: CURSOR okl_ove_opt_fk_csr (p_opt_id IN Okl_Options_V.id%TYPE,

280: p_ovev_rec IN OUT NOCOPY ovev_rec_type,
281: x_return_status OUT NOCOPY VARCHAR2,
282: x_valid OUT NOCOPY BOOLEAN
283: ) IS
284: CURSOR okl_ove_opt_fk_csr (p_opt_id IN Okl_Options_V.id%TYPE,
285: p_from_date IN Okl_Opt_Values_V.from_date%TYPE,
286: p_to_date IN Okl_Opt_Values_V.TO_DATE%TYPE
287: ) IS
288: SELECT '1'

Line 289: FROM Okl_Options_V opt

285: p_from_date IN Okl_Opt_Values_V.from_date%TYPE,
286: p_to_date IN Okl_Opt_Values_V.TO_DATE%TYPE
287: ) IS
288: SELECT '1'
289: FROM Okl_Options_V opt
290: WHERE opt.ID = p_opt_id
291: AND ((opt.FROM_DATE > p_from_date OR
292: p_from_date > NVL(opt.TO_DATE,p_from_date)) OR
293: NVL(opt.TO_DATE, p_to_date) < p_to_date);