APPS.OKL_SETUPPRODUCTS_PVT dependencies on OKL_PDT_OPTS_V

Line 332: FROM Okl_Pdt_Opts_V pon,

328: p_from_date > NVL(qve.TO_DATE,p_from_date)) OR
329: NVL(qve.TO_DATE, p_to_date) < p_to_date)
330: UNION ALL
331: SELECT '2'
332: FROM Okl_Pdt_Opts_V pon,
333: Okl_Options_V opt
334: WHERE pon.PDT_ID = p_pdt_id
335: AND opt.ID = pon.OPT_ID
336: AND ((opt.FROM_DATE > p_from_date OR

Line 341: FROM Okl_Pdt_Opts_V pon,

337: p_from_date > NVL(opt.TO_DATE,p_from_date)) OR
338: NVL(opt.TO_DATE, p_to_date) < p_to_date)
339: UNION ALL
340: SELECT '3'
341: FROM Okl_Pdt_Opts_V pon,
342: Okl_Pdt_Opt_Vals_V pov,
343: Okl_Opt_Values_V ove
344: WHERE pon.PDT_ID = p_pdt_id
345: AND pov.PON_ID = pon.ID

Line 3463: CURSOR okl_ponv_fk_csr (p_pdt_id IN Okl_Pdt_Opts_V.pdt_id%TYPE) IS

3459: x_return_status OUT NOCOPY VARCHAR2,
3460: x_count OUT NOCOPY NUMBER,
3461: x_ponv_tbl OUT NOCOPY ponv_tbl_type
3462: ) IS
3463: CURSOR okl_ponv_fk_csr (p_pdt_id IN Okl_Pdt_Opts_V.pdt_id%TYPE) IS
3464: SELECT ID,
3465: OPT_ID,
3466: OPTIONAL_YN,
3467: FROM_DATE,

Line 3469: FROM Okl_Pdt_Opts_V pon

3465: OPT_ID,
3466: OPTIONAL_YN,
3467: FROM_DATE,
3468: TO_DATE
3469: FROM Okl_Pdt_Opts_V pon
3470: WHERE pon.PDT_ID = p_pdt_id;
3471:
3472:
3473: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 3545: FROM Okl_Pdt_Opts_V pon,

3541: ove.OPT_ID OPT_ID,
3542: pov.OVE_ID OVE_ID,
3543: pov.FROM_DATE FROM_DATE,
3544: pov.TO_DATE TO_DATE
3545: FROM Okl_Pdt_Opts_V pon,
3546: Okl_Pdt_Opt_Vals_V pov,
3547: Okl_Opt_Values_V ove
3548: WHERE pon.PDT_ID = p_pdt_id
3549: AND pov.PON_ID = pon.ID