DBA Data[Home] [Help]

APPS.OKS_CONTRACTS_PUB dependencies on OKC_K_HEADERS_B

Line 3468: FROM okc_k_headers_b

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

Line 6148: Update Okc_k_headers_b

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