APPS.OKL_SETUPPQVALUES_PVT dependencies on OKL_PRODUCTS_V

Line 110: FROM Okl_products_V pdtv

106: ) IS
107: CURSOR okl_pdt_pk_csr (p_pdt_id IN NUMBER) IS
108: SELECT FROM_DATE,
109: TO_DATE
110: FROM Okl_products_V pdtv
111: WHERE pdtv.id = p_pdt_id;
112: l_okl_pdtv_pk okl_pdt_pk_csr%ROWTYPE;
113: l_pdtv_rec pdtv_rec_type;
114: BEGIN

Line 168: CURSOR okl_pqv_pdt_fk_csr (p_pdt_id IN Okl_Products_V.ID%TYPE,

164: ) IS
165: SELECT '1' FROM okl_k_headers_v khdr
166: WHERE khdr.pdt_id = p_pdt_id;
167:
168: CURSOR okl_pqv_pdt_fk_csr (p_pdt_id IN Okl_Products_V.ID%TYPE,
169: p_date IN Okl_Products_V.TO_DATE%TYPE
170: ) IS
171: SELECT '1'
172: FROM Okl_products_V pdt

Line 169: p_date IN Okl_Products_V.TO_DATE%TYPE

165: SELECT '1' FROM okl_k_headers_v khdr
166: WHERE khdr.pdt_id = p_pdt_id;
167:
168: CURSOR okl_pqv_pdt_fk_csr (p_pdt_id IN Okl_Products_V.ID%TYPE,
169: p_date IN Okl_Products_V.TO_DATE%TYPE
170: ) IS
171: SELECT '1'
172: FROM Okl_products_V pdt
173: WHERE pdt.ID = p_pdt_id

Line 172: FROM Okl_products_V pdt

168: CURSOR okl_pqv_pdt_fk_csr (p_pdt_id IN Okl_Products_V.ID%TYPE,
169: p_date IN Okl_Products_V.TO_DATE%TYPE
170: ) IS
171: SELECT '1'
172: FROM Okl_products_V pdt
173: WHERE pdt.ID = p_pdt_id
174: AND NVL(pdt.TO_DATE, p_date) < p_date;
175:
176: CURSOR okl_pqv_constraints_csr(p_qve_id IN Okl_Pdt_Pqy_Vals_V.QVE_ID%TYPE,

Line 239: FROM okl_products_v a,

235: cursor chk_deal_type(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,
236: p_qve_id okl_pdt_pqy_vals_v.qve_id%TYPE)
237: IS
238: SELECT DISTINCT C.deal_type
239: FROM okl_products_v a,
240: okl_ae_tmpt_sets_v b,
241: OKL_ST_GEN_TMPT_SETS c
242: WHERE a.aes_id = b.id
243: AND b.gts_id = c.id

Line 254: FROM okl_products_v a,

250: cursor chk_investor(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,
251: p_qve_id okl_pdt_pqy_vals_v.qve_id%TYPE)
252: IS
253: SELECT DISTINCT decode (C.deal_type, 'SALE','SECURITIZATION','SYNDICATION','SYNDICATION') DEAL_TYPE
254: FROM okl_products_v a,
255: okl_ae_tmpt_sets_v b,
256: OKL_ST_GEN_TMPT_SETS c
257: WHERE a.aes_id = b.id
258: AND b.gts_id = c.id

Line 268: FROM okl_products_v a,

264: cursor chk_tax_owner(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,
265: p_qve_id okl_pdt_pqy_vals_v.qve_id%TYPE)
266: IS
267: SELECT DISTINCT C.TAX_OWNER
268: FROM okl_products_v a,
269: okl_ae_tmpt_sets_v b,
270: OKL_ST_GEN_TMPT_SETS c
271: WHERE a.aes_id = b.id
272: AND b.gts_id = c.id

Line 282: FROM okl_products_v a,

278: cursor chk_intrst_calc_mthd(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,
279: p_qve_id okl_pdt_pqy_vals_v.qve_id%TYPE)
280: IS
281: SELECT DISTINCT C.INTEREST_CALC_METH_CODE
282: FROM okl_products_v a,
283: okl_ae_tmpt_sets_v b,
284: OKL_ST_GEN_TMPT_SETS c
285: WHERE a.aes_id = b.id
286: AND b.gts_id = c.id

Line 296: FROM okl_products_v a,

292: cursor chk_rev_rec_methd(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,
293: p_qve_id okl_pdt_pqy_vals_v.qve_id%TYPE)
294: IS
295: SELECT DISTINCT C.REVENUE_RECOG_METH_CODE
296: FROM okl_products_v a,
297: okl_ae_tmpt_sets_v b,
298: OKL_ST_GEN_TMPT_SETS c
299: WHERE a.aes_id = b.id
300: AND b.gts_id = c.id