APPS.OKL_SETUPPDTTEMPLATES_PVT dependencies on OKL_PDT_PQYS_V

Line 254: FROM Okl_Pdt_Pqys_V pdq,

250: p_from_date > NVL(ptv.TO_DATE,p_from_date)) OR
251: NVL(ptv.TO_DATE, p_to_date) < p_to_date)
252: UNION ALL
253: SELECT '2'
254: FROM Okl_Pdt_Pqys_V pdq,
255: Okl_Pdt_Qualitys_V pqy
256: WHERE pdq.PTL_ID = p_ptl_id
257: AND pqy.ID = pdq.PQY_ID
258: AND ((pqy.FROM_DATE > p_from_date OR

Line 649: CURSOR okl_pdqv_fk_csr (p_ptl_id IN Okl_Pdt_Pqys_V.ptl_id%TYPE) IS

645: x_return_status OUT NOCOPY VARCHAR2,
646: x_count OUT NOCOPY NUMBER,
647: x_pdqv_tbl OUT NOCOPY pdqv_tbl_type
648: ) IS
649: CURSOR okl_pdqv_fk_csr (p_ptl_id IN Okl_Pdt_Pqys_V.ptl_id%TYPE) IS
650: SELECT ID,
651: PQY_ID,
652: FROM_DATE,
653: TO_DATE

Line 654: FROM Okl_Pdt_Pqys_V pdq

650: SELECT ID,
651: PQY_ID,
652: FROM_DATE,
653: TO_DATE
654: FROM Okl_Pdt_Pqys_V pdq
655: WHERE pdq.PTL_ID = p_ptl_id;
656:
657: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
658: l_count NUMBER := 0;