3248: pdt.ID pid,
3249: NVL (pdt.reporting_pdt_id, -1) report_pdt_id,
3250: CHR.currency_code currency_code,
3251: khr.term_duration term
3252: FROM okc_k_headers_v CHR, okl_k_headers khr, okl_products_v pdt
3253: WHERE khr.ID = CHR.ID AND CHR.ID = chrid AND khr.pdt_id = pdt.ID(+);
3254:
3255: l_hdr_rec l_hdr_csr%ROWTYPE;
3256: p_pdtv_rec okl_setupproducts_pub.pdtv_rec_type;
3436: --ramurt Bug#4622438
3437: CURSOR chk_product_status (p_chr_id IN NUMBER) IS
3438: SELECT pdt.NAME,
3439: pdt.product_status_code
3440: FROM okl_products_v pdt, okl_k_headers_v khr, okc_k_headers_b CHR
3441: WHERE 1 = 1
3442: AND khr.ID = p_chr_id
3443: AND pdt_id = pdt.ID
3444: AND khr.ID = CHR.ID;
3442: AND khr.ID = p_chr_id
3443: AND pdt_id = pdt.ID
3444: AND khr.ID = CHR.ID;
3445:
3446: l_product_status_code okl_products_v.product_status_code%TYPE;
3447: l_product_name okl_products_v.NAME%TYPE;
3448: -- 4577840 end
3449: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
3450: -- 4895333;
3443: AND pdt_id = pdt.ID
3444: AND khr.ID = CHR.ID;
3445:
3446: l_product_status_code okl_products_v.product_status_code%TYPE;
3447: l_product_name okl_products_v.NAME%TYPE;
3448: -- 4577840 end
3449: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
3450: -- 4895333;
3451: --Bug# 4631549