APPS.OKL_SETUPPRODUCTS_PVT dependencies on OKL_PDT_TEMPLATES_V

Line 375: FROM Okl_Pdt_Templates_V PTL

371: p_from_date > NVL(aes.END_DATE,p_from_date)) OR
372: NVL(aes.END_DATE, p_to_date) < p_to_date)
373: UNION ALL
374: SELECT '2'
375: FROM Okl_Pdt_Templates_V PTL
376: WHERE PTL.ID = p_ptl_id
377: AND ((PTL.FROM_DATE > p_from_date OR
378: p_from_date > NVL(PTL.TO_DATE,p_from_date)) OR
379: NVL(PTL.TO_DATE, p_to_date) < p_to_date);

Line 389: CURSOR choose_qlty_csr(cp_ptl_id okl_pdt_templates_v.id%TYPE) IS

385: WHERE name = p_name
386:
387: AND version = p_version;
388:
389: CURSOR choose_qlty_csr(cp_ptl_id okl_pdt_templates_v.id%TYPE) IS
390: SELECT DISTINCT pqy.id id,
391: pqy.name name
392: FROM okl_pdt_qualitys_v pqy,
393: okl_pdt_pqys_v pdq

Line 2553: FROM okl_pdt_templates_v

2549: l_token_1 VARCHAR2(1999);
2550:
2551: CURSOR okl_ptlv_pk_csr (p_id IN NUMBER) IS
2552: SELECT '1'
2553: FROM okl_pdt_templates_v
2554: WHERE okl_pdt_templates_v.id = p_id;
2555:
2556: BEGIN
2557: -- initialize return status

Line 2554: WHERE okl_pdt_templates_v.id = p_id;

2550:
2551: CURSOR okl_ptlv_pk_csr (p_id IN NUMBER) IS
2552: SELECT '1'
2553: FROM okl_pdt_templates_v
2554: WHERE okl_pdt_templates_v.id = p_id;
2555:
2556: BEGIN
2557: -- initialize return status
2558: x_return_status := Okl_Api.G_RET_STS_SUCCESS;