APPS.OKL_SETUPPRODUCTS_PVT dependencies on OKL_PDT_PQY_VALS_V

Line 153: FROM okl_pdt_pqy_vals_v pqvv

149: l_del_pqvv_tbl OKL_PQY_VALUES_PUB.pqvv_tbl_type;
150:
151: CURSOR pqv_csr IS
152: SELECT pqvv.id
153: FROM okl_pdt_pqy_vals_v pqvv
154: WHERE pqvv.pdt_id = p_pdtv_rec.id;
155:
156: BEGIN
157:

Line 324: Okl_Pdt_Pqy_Vals_V pqv

320: p_to_date IN Okl_Products_V.TO_DATE%TYPE
321: ) IS
322: SELECT '1'
323: FROM Okl_Pqy_Values_V qve,
324: Okl_Pdt_Pqy_Vals_V pqv
325: WHERE pqv.PDT_ID = p_pdt_id
326: AND qve.ID = pqv.QVE_ID
327: AND ((qve.FROM_DATE > p_from_date OR
328: p_from_date > NVL(qve.TO_DATE,p_from_date)) OR

Line 1702: cursor chk_deal_type(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,

1698: AND a.deal_type = c.deal_type
1699: AND a.id = p_pdt_id;
1700:
1701: /*
1702: cursor chk_deal_type(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,
1703: p_aes_id okl_products_v.aes_id%TYPE)
1704: IS
1705: SELECT DISTINCT C.deal_type
1706: FROM okl_products_v a,

Line 1719: cursor chk_deal_type(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,

1715: select DEAL_TYPE from okl_product_parameters_v ppar
1716: where ppar.id = p_pdt_id;
1717:
1718:
1719: cursor chk_deal_type(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,
1720: p_qve_id okl_pdt_pqy_vals_v.qve_id%TYPE)
1721: IS
1722: SELECT DISTINCT C.deal_type
1723: FROM okl_products_v a,

Line 1720: p_qve_id okl_pdt_pqy_vals_v.qve_id%TYPE)

1716: where ppar.id = p_pdt_id;
1717:
1718:
1719: cursor chk_deal_type(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,
1720: p_qve_id okl_pdt_pqy_vals_v.qve_id%TYPE)
1721: IS
1722: SELECT DISTINCT C.deal_type
1723: FROM okl_products_v a,
1724: okl_ae_tmpt_sets_v b,

Line 3389: CURSOR okl_pqvv_fk_csr (p_pdt_id IN Okl_Pdt_Pqy_Vals_V.pdt_id%TYPE) IS

3385: x_return_status OUT NOCOPY VARCHAR2,
3386: x_count OUT NOCOPY NUMBER,
3387: x_pqvv_tbl OUT NOCOPY pqvv_tbl_type
3388: ) IS
3389: CURSOR okl_pqvv_fk_csr (p_pdt_id IN Okl_Pdt_Pqy_Vals_V.pdt_id%TYPE) IS
3390: SELECT ID,
3391: PDQ_ID,
3392: QVE_ID,
3393: FROM_DATE,

Line 3395: FROM Okl_pdt_pqy_vals_V pqv

3391: PDQ_ID,
3392: QVE_ID,
3393: FROM_DATE,
3394: TO_DATE
3395: FROM Okl_pdt_pqy_vals_V pqv
3396: WHERE pqv.PDT_ID = p_pdt_id;
3397:
3398: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3399: l_count NUMBER := 0;