APPS.OKS_MASS_UPD_PVT dependencies on OKS_K_LINES_B

Line 518: FROM okc_k_lines_b cleb, oks_k_lines_B kln

514: WHERE id = p_contract_id;
515:
516: cursor cur_line(p_subline_id in number) is
517: SELECT cleb.price_negotiated, kln.tax_amount
518: FROM okc_k_lines_b cleb, oks_k_lines_B kln
519: WHERE cleb.id = p_subline_id
520: AND cleb.id = kln.cle_id;
521:
522: -- Header Tax Total

Line 525: FROM okc_k_lines_b cle, oks_k_lines_b kln

521:
522: -- Header Tax Total
523: Cursor hdrtax_cur(p_chr_id In Number) Is
524: SELECT SUM(kln.tax_amount)
525: FROM okc_k_lines_b cle, oks_k_lines_b kln
526: WHERE cle.dnz_chr_id = p_chr_id
527: AND cle.id = kln.cle_id
528: AND cle.lse_id IN (7, 8, 9, 10, 11, 13, 35, 25, 46)
529: AND cle.date_cancelled IS NULL;

Line 534: FROM okc_k_lines_b cle, oks_k_lines_b kln

530:
531: -- Topline Tax Total
532: Cursor toplinetax_cur(p_cle_id In Number) Is
533: SELECT SUM(tax_amount)
534: FROM okc_k_lines_b cle, oks_k_lines_b kln
535: WHERE cle.cle_id = p_cle_id
536: AND cle.id = kln.cle_id
537: AND cle.lse_id IN (7, 8, 9, 10, 11, 13, 35, 25, 46)
538: AND cle.date_cancelled IS NULL;