APPS.OKS_OCINT_PUB dependencies on OKC_K_HEADERS_ALL_B

Line 2593: UPDATE okc_k_headers_all_b --mmadhavi _all for MOAC

2589: FROM okc_k_lines_b
2590: WHERE cle_id = l_lineid AND dnz_chr_id = l_chrid)
2591: WHERE ID = l_lineid;
2592: END IF;
2593: UPDATE okc_k_headers_all_b --mmadhavi _all for MOAC
2594: SET estimated_amount =
2595: (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0)
2596: FROM okc_k_lines_b
2597: WHERE dnz_chr_id = l_chrid AND lse_id IN (1, 19, 46)) ---Modified for ER16039680

Line 2958: -- UPDATE okc_k_headers_all_b --mmadhavi _all for MOAC

2954: -- FROM okc_k_lines_b
2955: -- WHERE cle_id = l_lineid AND dnz_chr_id = l_chrid)
2956: -- WHERE ID = l_lineid;
2957: --
2958: -- UPDATE okc_k_headers_all_b --mmadhavi _all for MOAC
2959: -- SET estimated_amount =
2960: -- (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0)
2961: -- FROM okc_k_lines_b
2962: -- WHERE dnz_chr_id = l_chrid AND lse_id IN (1, 19))

Line 4889: FROM okc_k_headers_all_b okhb,okc_k_lines_b okcl

4885: WHERE instance_id = p_cp_id;
4886:
4887: CURSOR l_contract_hdr_dtls IS
4888: SELECT okhb.start_date,okhb.end_date,okcl.cust_acct_id,okcl.sts_code
4889: FROM okc_k_headers_all_b okhb,okc_k_lines_b okcl
4890: WHERE okhb.id=okcl.chr_id
4891: AND okcl.id=p_cle_id;
4892:
4893: