3464: --END NPALEPU
3465:
3466: CURSOR l_header_csr (p_header_id number) IS
3467: SELECT id,scs_code
3468: FROM okc_k_headers_b
3469: WHERE id = p_header_id;
3470:
3471: CURSOR l_template_csr (p_srv_id NUMBER, p_orgid NUMBER) IS
3472: SELECT coverage_template_id
6144:
6145: END IF;
6146: End If;
6147:
6148: Update Okc_k_headers_b
6149: Set Estimated_amount = (Select nvl(sum(nvl(price_negotiated,0)),0)
6150: from Okc_k_lines_b
6151: Where dnz_chr_id = l_contract_header_id
6152: and lse_id in (9,25,46))