141: WHERE ptvv.id = p_ptl_id
142: AND ptvv.id = pdtv.ptl_id
143: AND pdtv.id = khdr.pdt_id;
144:
145: CURSOR okl_pmv_ptl_fk_csr (p_ptl_id IN Okl_Products_V.ID%TYPE,
146: p_date IN Okl_Products_V.TO_DATE%TYPE
147: ) IS
148: SELECT '1'
149: FROM Okl_pdt_templates_V ptl
142: AND ptvv.id = pdtv.ptl_id
143: AND pdtv.id = khdr.pdt_id;
144:
145: CURSOR okl_pmv_ptl_fk_csr (p_ptl_id IN Okl_Products_V.ID%TYPE,
146: p_date IN Okl_Products_V.TO_DATE%TYPE
147: ) IS
148: SELECT '1'
149: FROM Okl_pdt_templates_V ptl
150: WHERE ptl.ID = p_ptl_id