DBA Data[Home] [Help]

APPS.OKL_SETUPDQUALITYS_PVT dependencies on OKL_PRODUCTS_V

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