APPS.OKL_CONTRACT_BOOK_PVT dependencies on OKL_PRODUCTS_V

Line 3555: FROM okc_k_headers_v CHR, okl_k_headers khr, okl_products_v pdt

3551: pdt.ID pid,
3552: NVL (pdt.reporting_pdt_id, -1) report_pdt_id,
3553: CHR.currency_code currency_code,
3554: khr.term_duration term
3555: FROM okc_k_headers_v CHR, okl_k_headers khr, okl_products_v pdt
3556: WHERE khr.ID = CHR.ID AND CHR.ID = chrid AND khr.pdt_id = pdt.ID(+);
3557:
3558: l_hdr_rec l_hdr_csr%ROWTYPE;
3559: p_pdtv_rec okl_setupproducts_pub.pdtv_rec_type;

Line 3743: FROM okl_products_v pdt, okl_k_headers_v khr, okc_k_headers_b CHR

3739: --ramurt Bug#4622438
3740: CURSOR chk_product_status (p_chr_id IN NUMBER) IS
3741: SELECT pdt.NAME,
3742: pdt.product_status_code
3743: FROM okl_products_v pdt, okl_k_headers_v khr, okc_k_headers_b CHR
3744: WHERE 1 = 1
3745: AND khr.ID = p_chr_id
3746: AND pdt_id = pdt.ID
3747: AND khr.ID = CHR.ID;

Line 3749: l_product_status_code okl_products_v.product_status_code%TYPE;

3745: AND khr.ID = p_chr_id
3746: AND pdt_id = pdt.ID
3747: AND khr.ID = CHR.ID;
3748:
3749: l_product_status_code okl_products_v.product_status_code%TYPE;
3750: l_product_name okl_products_v.NAME%TYPE;
3751: -- 4577840 end
3752: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
3753: -- 4895333;

Line 3750: l_product_name okl_products_v.NAME%TYPE;

3746: AND pdt_id = pdt.ID
3747: AND khr.ID = CHR.ID;
3748:
3749: l_product_status_code okl_products_v.product_status_code%TYPE;
3750: l_product_name okl_products_v.NAME%TYPE;
3751: -- 4577840 end
3752: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
3753: -- 4895333;
3754: --Bug# 4631549