APPS.OKL_SETUPDQUALITYS_PVT dependencies on OKL_PDT_TEMPLATES_V

Line 94: FROM Okl_pdt_templates_V ptlv

90: ) IS
91: CURSOR okl_ptl_pk_csr (p_ptl_id IN NUMBER) IS
92: SELECT FROM_DATE,
93: TO_DATE
94: FROM Okl_pdt_templates_V ptlv
95: WHERE ptlv.id = p_ptl_id;
96: l_okl_ptlv_pk okl_ptl_pk_csr%ROWTYPE;
97: l_ptlv_rec ptlv_rec_type;
98: BEGIN

Line 143: SELECT '1' FROM okl_pdt_templates_v ptlv,

139: x_valid OUT NOCOPY BOOLEAN
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:

Line 155: FROM Okl_pdt_templates_V ptl

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
157: AND NVL(ptl.TO_DATE, p_date) < p_date;
158:
159: CURSOR okl_pdq_constraints_csr (p_pqy_id IN Okl_Pdt_Qualitys_V.ID%TYPE,