APPS.OKC_COPY_CONTRACT_PVT dependencies on OKS_K_LINES_B

Line 11510: FROM okc_k_lines_b okcb, oks_k_lines_b oksb

11506: l_include_terminated_lines varchar2(1) := p_include_terminated_lines;
11507:
11508: CURSOR l_lines_csr(p_chr_id in number) IS
11509: SELECT COUNT(date_cancelled), COUNT(date_terminated)
11510: FROM okc_k_lines_b okcb, oks_k_lines_b oksb
11511: WHERE okcb.id = oksb.cle_id
11512: AND okcb.dnz_chr_id = p_chr_id;
11513: BEGIN
11514: -- hkamdar R12 Copy MOAC changes

Line 11869: FROM OKS_K_LINES_B

11865:
11866: -- Get current billing type
11867: CURSOR get_billing_type_csr(p_cle_id IN NUMBER) IS
11868: SELECT billing_schedule_type
11869: FROM OKS_K_LINES_B
11870: WHERE cle_id = p_cle_id
11871: and dnz_chr_id = p_chr_id;
11872:
11873:

Line 11877: FROM OKS_K_LINES_B

11873:
11874: -- Get current ARL rule.
11875: CURSOR get_arl_csr(p_cle_id IN NUMBER) IS
11876: SELECT id,acct_rule_id, object_version_number
11877: FROM OKS_K_LINES_B
11878: WHERE cle_id = p_cle_id
11879: and dnz_chr_id = p_chr_id;
11880:
11881: -- Get Estimation date

Line 11891: FROM okc_k_lines_b cle, oks_k_lines_b kln

11887:
11888: --npalepu added on 27-FEB-2007 for bug # 5671352
11889: CURSOR toplinetax_cur(p_cle_id IN NUMBER) IS
11890: SELECT SUM(nvl(tax_amount, 0)) amount
11891: FROM okc_k_lines_b cle, oks_k_lines_b kln
11892: WHERE cle.cle_id = p_cle_id
11893: AND cle.id = kln.cle_id
11894: AND cle.lse_id IN (7, 8, 9, 10, 11, 13, 35, 25)
11895: AND cle.date_cancelled IS NULL;

Line 11902: FROM oks_k_lines_b

11898: l_topline_count NUMBER;
11899:
11900: CURSOR Get_oks_Lines_details(p_cle_id IN NUMBER) IS
11901: SELECT id, object_version_number, dnz_chr_id
11902: FROM oks_k_lines_b
11903: WHERE cle_id = p_cle_id ;
11904:
11905: l_get_oks_details Get_oks_Lines_details%ROWTYPE;
11906: l_klnv_tax_tbl_in oks_contract_line_pub.klnv_tbl_type;

Line 11911: FROM okc_k_lines_b cle, oks_k_lines_b kln

11907: l_klnv_tax_tbl_out oks_contract_line_pub.klnv_tbl_type;
11908:
11909: CURSOR hdrtax_cur IS
11910: SELECT SUM(kln.tax_amount) amount
11911: FROM okc_k_lines_b cle, oks_k_lines_b kln
11912: WHERE cle.dnz_chr_id = p_chr_id
11913: AND cle.id = kln.cle_id
11914: AND cle.lse_id IN (7, 8, 9, 10, 11, 13, 35, 25, 46)
11915: AND cle.date_cancelled IS NULL;