APPS.OKL_SETUPPOVALUES_PVT dependencies on OKL_PRODUCTS_V

Line 141: CURSOR okl_pov_pdt_fk_csr(p_pon_id IN Okl_Products_V.ID%TYPE,

137: okl_k_headers_v khdr
138: WHERE ponv.id = p_pon_id AND
139: khdr.pdt_id = ponv.pdt_id;
140:
141: CURSOR okl_pov_pdt_fk_csr(p_pon_id IN Okl_Products_V.ID%TYPE,
142: p_date IN Okl_Products_V.TO_DATE%TYPE
143: ) IS
144: SELECT '1'
145: FROM Okl_products_V pdt,

Line 142: p_date IN Okl_Products_V.TO_DATE%TYPE

138: WHERE ponv.id = p_pon_id AND
139: khdr.pdt_id = ponv.pdt_id;
140:
141: CURSOR okl_pov_pdt_fk_csr(p_pon_id IN Okl_Products_V.ID%TYPE,
142: p_date IN Okl_Products_V.TO_DATE%TYPE
143: ) IS
144: SELECT '1'
145: FROM Okl_products_V pdt,
146: Okl_pdt_opts_V pon

Line 145: FROM Okl_products_V pdt,

141: CURSOR okl_pov_pdt_fk_csr(p_pon_id IN Okl_Products_V.ID%TYPE,
142: p_date IN Okl_Products_V.TO_DATE%TYPE
143: ) IS
144: SELECT '1'
145: FROM Okl_products_V pdt,
146: Okl_pdt_opts_V pon
147: WHERE pdt.id = pon.pdt_id
148: AND pon.ID = p_pon_id
149: AND NVL(pdt.TO_DATE, p_date) < p_date;