APPS.OKL_SETUPDQUALITYS_PVT dependencies on OKL_PRODUCTS

Line 144: okl_products pdtv,

140: ) IS
141: CURSOR okl_pdqv_chk(p_ptl_id NUMBER
142: ) IS
143: SELECT '1' FROM okl_pdt_templates_v ptlv,
144: okl_products pdtv,
145: okl_k_headers_v khdr
146: WHERE ptlv.id = p_ptl_id AND
147:
148: ptlv.id = pdtv.ptl_id AND

Line 151: CURSOR okl_pdq_ptl_fk_csr (p_ptl_id IN Okl_Products_V.ID%TYPE,

147:
148: ptlv.id = pdtv.ptl_id AND
149: pdtv.id = khdr.pdt_id;
150:
151: CURSOR okl_pdq_ptl_fk_csr (p_ptl_id IN Okl_Products_V.ID%TYPE,
152: p_date IN Okl_Products_V.TO_DATE%TYPE
153: ) IS
154: SELECT '1'
155: FROM Okl_pdt_templates_V ptl

Line 152: p_date IN Okl_Products_V.TO_DATE%TYPE

148: ptlv.id = pdtv.ptl_id AND
149: pdtv.id = khdr.pdt_id;
150:
151: CURSOR okl_pdq_ptl_fk_csr (p_ptl_id IN Okl_Products_V.ID%TYPE,
152: p_date IN Okl_Products_V.TO_DATE%TYPE
153: ) IS
154: SELECT '1'
155: FROM Okl_pdt_templates_V ptl
156: WHERE ptl.ID = p_ptl_id