APPS.OKS_BILLING_PROFILES_PUB dependencies on OKC_K_LINES_B

Line 69: FROM okc_k_headers_b contract, okc_k_lines_b line

65: IS
66:
67: CURSOR l_line_cur IS
68: SELECT contract.currency_code
69: FROM okc_k_headers_b contract, okc_k_lines_b line
70: WHERE contract.id = line.dnz_chr_id and line.id = p_cle_id;
71:
72: CURSOR l_hdr_cur IS
73: SELECT contract.currency_code

Line 1202: FROM okc_k_lines_b line, oks_k_lines_b dtl

1198: /* cgopinee bugfix for 7596241*/
1199: CURSOR l_line_amt_csr(p_cle_id NUMBER) IS
1200: SELECT (nvl(line.price_negotiated,0) + nvl(dtl.ubt_amount,0) +
1201: nvl(dtl.credit_amount,0) + nvl(dtl.suppressed_credit,0)) line_amt
1202: FROM okc_k_lines_b line, oks_k_lines_b dtl
1203: WHERE line.id = dtl.cle_id AND line.Id = p_cle_id ;
1204:
1205: l_api_version CONSTANT NUMBER := 1.0;
1206: l_return_status VARCHAR2(200);

Line 1239: from okc_k_lines_b

1235: -- Bug 5202220
1236:
1237: Cursor csr_get_lse_id (p_cle_id number, p_chr_id number) IS
1238: select lse_id
1239: from okc_k_lines_b
1240: where id = p_cle_id
1241: and dnz_chr_id = p_chr_id;
1242:
1243: l_lse_id number;