APPS.OKL_SETUPPDTTEMPLATES_PVT dependencies on OKL_PTL_PTQ_VALS_V

Line 246: Okl_Ptl_Ptq_Vals_V pmv

242: p_to_date IN Okl_Pdt_Templates_V.TO_DATE%TYPE
243: ) IS
244: SELECT '1'
245: FROM Okl_Ptq_Values_V ptv,
246: Okl_Ptl_Ptq_Vals_V pmv
247: WHERE pmv.PTL_ID = p_ptl_id
248: AND ptv.ID = pmv.PTV_ID
249: AND ((ptv.FROM_DATE > p_from_date OR
250: p_from_date > NVL(ptv.TO_DATE,p_from_date)) OR

Line 578: CURSOR okl_pmvv_fk_csr (p_ptl_id IN Okl_Ptl_Ptq_Vals_V.ptl_id%TYPE) IS

574: x_return_status OUT NOCOPY VARCHAR2,
575: x_count OUT NOCOPY NUMBER,
576: x_pmvv_tbl OUT NOCOPY pmvv_tbl_type
577: ) IS
578: CURSOR okl_pmvv_fk_csr (p_ptl_id IN Okl_Ptl_Ptq_Vals_V.ptl_id%TYPE) IS
579: SELECT ID,
580: PTQ_ID,
581: PTV_ID,
582: FROM_DATE,

Line 584: FROM Okl_Ptl_Ptq_Vals_V pmv

580: PTQ_ID,
581: PTV_ID,
582: FROM_DATE,
583: TO_DATE
584: FROM Okl_Ptl_Ptq_Vals_V pmv
585: WHERE pmv.PTL_ID = p_ptl_id;
586:
587: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
588: l_count NUMBER := 0;