APPS.OKL_CONTRACT_BOOK_PVT dependencies on OKL_K_HEADERS

Line 316: FROM okc_k_headers_v CHR, okl_k_headers khr

312: x_batch_number NUMBER;
313:
314: CURSOR l_dltype_csr (chrid NUMBER) IS
315: SELECT khr.deal_type
316: FROM okc_k_headers_v CHR, okl_k_headers khr
317: WHERE CHR.ID = khr.ID AND CHR.ID = chrid;
318:
319: l_dltype_rec l_dltype_csr%ROWTYPE;
320:

Line 324: FROM okc_k_headers_b chrb, okl_k_headers khr

320:
321: CURSOR l_ptmpl_csr (p_chr_id IN NUMBER) IS
322: SELECT chrb.template_yn,
323: khr.template_type_code
324: FROM okc_k_headers_b chrb, okl_k_headers khr
325: WHERE chrb.ID = khr.ID AND chrb.ID = p_chr_id;
326:
327: l_template_type_code okl_k_headers.template_type_code%TYPE;
328: l_template_yn okc_k_headers_b.template_yn%TYPE;

Line 327: l_template_type_code okl_k_headers.template_type_code%TYPE;

323: khr.template_type_code
324: FROM okc_k_headers_b chrb, okl_k_headers khr
325: WHERE chrb.ID = khr.ID AND chrb.ID = p_chr_id;
326:
327: l_template_type_code okl_k_headers.template_type_code%TYPE;
328: l_template_yn okc_k_headers_b.template_yn%TYPE;
329: l_pqcl_id okc_k_headers_b.qcl_id%TYPE;
330:
331: CURSOR l_ptmpl_qcl_csr (p_chr_id IN NUMBER) IS

Line 1548: FROM okc_k_headers_b CHR, okl_k_headers khr

1544: --cursor to check for vendor program template
1545: CURSOR l_chk_template_csr (p_chr_id IN NUMBER) IS
1546: SELECT CHR.template_yn,
1547: khr.template_type_code
1548: FROM okc_k_headers_b CHR, okl_k_headers khr
1549: WHERE CHR.ID = p_chr_id AND CHR.ID = khr.ID;
1550:
1551: l_chk_template_rec l_chk_template_csr%ROWTYPE;
1552:

Line 1920: CURSOR l_svclne_csr (ltycode VARCHAR2, chrid okl_k_headers.khr_id%TYPE) IS

1916: WHERE ID = chrid;
1917:
1918: l_sts_rec l_sts_csr%ROWTYPE;
1919:
1920: CURSOR l_svclne_csr (ltycode VARCHAR2, chrid okl_k_headers.khr_id%TYPE) IS
1921: SELECT cle.ID,
1922: cle.price_negotiated amount
1923: FROM okc_k_lines_b cle, okc_line_styles_b ls, okc_statuses_b sts
1924: WHERE cle.lse_id = ls.ID

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 3713: FROM okc_k_headers_b CHR, okl_k_headers khr

3709: --cursor to check for vendor program template
3710: CURSOR l_chk_template_csr (p_chr_id IN NUMBER) IS
3711: SELECT CHR.template_yn,
3712: khr.template_type_code
3713: FROM okc_k_headers_b CHR, okl_k_headers khr
3714: WHERE CHR.ID = p_chr_id AND CHR.ID = khr.ID;
3715:
3716: l_chk_template_rec l_chk_template_csr%ROWTYPE;
3717:

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;