APPS.OKC_COPY_CONTRACT_PVT dependencies on OKS_K_LINES_B

Line 11511: FROM okc_k_lines_b okcb, oks_k_lines_b oksb

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

Line 11870: FROM OKS_K_LINES_B

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

Line 11878: FROM OKS_K_LINES_B

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

Line 11892: FROM okc_k_lines_b cle, oks_k_lines_b kln

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

Line 11903: FROM oks_k_lines_b

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

Line 11912: FROM okc_k_lines_b cle, oks_k_lines_b kln

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