APPS.OKS_ATTR_DEFAULTS_PVT dependencies on OKS_K_LINES_B

Line 732: from oks_k_lines_b oks, okc_k_lines_b okc

728: cust_po_number,
729: cust_po_number_req_yn,
730: payment_instruction_type,
731: trxn_extension_id
732: from oks_k_lines_b oks, okc_k_lines_b okc
733: where okc.id = p_cle_id
734: and oks.cle_id = okc.id;
735: -- END GCHADHA --
736:

Line 755: FROM OKS_k_LINES_B

751:
752: Cursor cur_get_lines_details (p_chr_id IN NUMBER, p_cle_id IN NUMBER) IS
753: Select locked_price_list_id ,
754: locked_price_list_line_id
755: FROM OKS_k_LINES_B
756: WHERE dnz_chr_id = p_chr_id
757: and cle_id = p_cle_id ;
758:
759: -- Ebtax --

Line 772: from okc_k_lines_b cle, oks_k_lines_b sle

768: -- Recalculate Tax --
769: -- Bug 4717842 --
770: CURSOR get_topline_tax_amt_csr (p_cle_id IN NUMBER) IS
771: Select nvl(sum(nvl(tax_amount,0)),0) tax_amount
772: from okc_k_lines_b cle, oks_k_lines_b sle
773: where cle.cle_id = p_cle_id
774: and cle.lse_id in (7,8,9,10,11,13,25,35)
775: and cle.id = sle.cle_id
776: and cle.dnz_chr_id = sle.dnz_chr_id

Line 781: from okc_k_lines_b cle, oks_k_lines_b sle

777: and cle.date_cancelled is null;
778:
779: Cursor get_hdr_tax_amt_csr (p_chr_id in number) IS
780: Select nvl(sum(nvl(tax_amount,0)),0) tax_amount
781: from okc_k_lines_b cle, oks_k_lines_b sle
782: where cle.chr_id = p_chr_id
783: and cle.id = sle.cle_id
784: and cle.dnz_chr_id = sle.dnz_chr_id
785: and cle.date_cancelled is null;