APPS.OKL_CONTRACT_BOOK_PVT dependencies on OKL_K_HEADERS

Line 222: FROM okc_k_headers_v CHR, okl_k_headers khr

218: x_batch_number NUMBER;
219:
220: CURSOR l_dltype_csr (chrid NUMBER) IS
221: SELECT khr.deal_type
222: FROM okc_k_headers_v CHR, okl_k_headers khr
223: WHERE CHR.ID = khr.ID AND CHR.ID = chrid;
224:
225: l_dltype_rec l_dltype_csr%ROWTYPE;
226:

Line 230: FROM okc_k_headers_b chrb, okl_k_headers khr

226:
227: CURSOR l_ptmpl_csr (p_chr_id IN NUMBER) IS
228: SELECT chrb.template_yn,
229: khr.template_type_code
230: FROM okc_k_headers_b chrb, okl_k_headers khr
231: WHERE chrb.ID = khr.ID AND chrb.ID = p_chr_id;
232:
233: l_template_type_code okl_k_headers.template_type_code%TYPE;
234: l_template_yn okc_k_headers_b.template_yn%TYPE;

Line 233: l_template_type_code okl_k_headers.template_type_code%TYPE;

229: khr.template_type_code
230: FROM okc_k_headers_b chrb, okl_k_headers khr
231: WHERE chrb.ID = khr.ID AND chrb.ID = p_chr_id;
232:
233: l_template_type_code okl_k_headers.template_type_code%TYPE;
234: l_template_yn okc_k_headers_b.template_yn%TYPE;
235: l_pqcl_id okc_k_headers_b.qcl_id%TYPE;
236:
237: CURSOR l_ptmpl_qcl_csr (p_chr_id IN NUMBER) IS

Line 825: FROM okc_statuses_v a, okc_k_headers_b b, okl_k_headers c

821: l_failstatus VARCHAR2 (256);
822:
823: CURSOR tmp_csr (chrid NUMBER) IS
824: SELECT NVL (b.template_yn, 'N') template_yn
825: FROM okc_statuses_v a, okc_k_headers_b b, okl_k_headers c
826: WHERE a.code = b.sts_code AND b.ID = c.ID AND b.ID = chrid;
827:
828: tmp_rec tmp_csr%ROWTYPE;
829:

Line 1246: FROM okc_k_headers_b CHR, okl_k_headers khr

1242: --cursor to check for vendor program template
1243: CURSOR l_chk_template_csr (p_chr_id IN NUMBER) IS
1244: SELECT CHR.template_yn,
1245: khr.template_type_code
1246: FROM okc_k_headers_b CHR, okl_k_headers khr
1247: WHERE CHR.ID = p_chr_id AND CHR.ID = khr.ID;
1248:
1249: l_chk_template_rec l_chk_template_csr%ROWTYPE;
1250:

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

1612: WHERE ID = chrid;
1613:
1614: l_sts_rec l_sts_csr%ROWTYPE;
1615:
1616: CURSOR l_svclne_csr (ltycode VARCHAR2, chrid okl_k_headers.khr_id%TYPE) IS
1617: SELECT cle.ID,
1618: cle.price_negotiated amount
1619: FROM okc_k_lines_b cle, okc_line_styles_b ls, okc_statuses_b sts
1620: WHERE cle.lse_id = ls.ID

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

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;

Line 3410: FROM okc_k_headers_b CHR, okl_k_headers khr

3406: --cursor to check for vendor program template
3407: CURSOR l_chk_template_csr (p_chr_id IN NUMBER) IS
3408: SELECT CHR.template_yn,
3409: khr.template_type_code
3410: FROM okc_k_headers_b CHR, okl_k_headers khr
3411: WHERE CHR.ID = p_chr_id AND CHR.ID = khr.ID;
3412:
3413: l_chk_template_rec l_chk_template_csr%ROWTYPE;
3414:

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

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;