APPS.OKS_BILLING_PROFILES_PUB dependencies on OKS_K_LINES_B

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);