APPS.OKL_SETUPPOVALUES_PVT dependencies on OKL_PDT_OPTS_V

Line 74: -- PROCEDURE get_parent_dates for: OKL_PDT_OPTS_V

70:
71: END get_rec;
72:
73: ---------------------------------------------------------------------------
74: -- PROCEDURE get_parent_dates for: OKL_PDT_OPTS_V
75: ---------------------------------------------------------------------------
76:
77: PROCEDURE get_parent_dates(
78: p_povv_rec IN povv_rec_type,

Line 86: FROM Okl_pdt_opts_V ponv

82: ) IS
83: CURSOR okl_ponv_pk_csr (p_pon_id IN NUMBER) IS
84: SELECT FROM_DATE,
85: TO_DATE
86: FROM Okl_pdt_opts_V ponv
87: WHERE ponv.id = p_pon_id;
88: l_okl_ponv_pk okl_ponv_pk_csr%ROWTYPE;
89: l_ponv_rec ponv_rec_type;
90: BEGIN

Line 136: SELECT '1' FROM okl_pdt_opts_v ponv,

132: ) IS
133:
134: CURSOR okl_povv_chk(p_pon_id NUMBER
135: ) IS
136: SELECT '1' FROM okl_pdt_opts_v ponv,
137: okl_k_headers_v khdr
138: WHERE ponv.id = p_pon_id AND
139: khdr.pdt_id = ponv.pdt_id;
140:

Line 146: Okl_pdt_opts_V pon

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;
150: