APPS.OKL_DEAL_CREAT_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 4842: FROM okc_k_headers_all_b

4838: AND rgd_code = p_rgd_code;
4839:
4840: CURSOR c_orig_system_source(p_chr_id NUMBER) IS
4841: SELECT orig_system_source_code
4842: FROM okc_k_headers_all_b
4843: WHERE id = p_chr_id;
4844:
4845: --Added by bkatraga for bug 9343568
4846: CURSOR c_check_rule(p_chr_id NUMBER, p_rgd_code VARCHAR2, p_rule_cat VARCHAR2) IS

Line 9026: CURSOR c_hdr_full_uv(p_chr_id OKC_K_HEADERS_ALL_B.ID%TYPE) IS

9022: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
9023: l_api_name CONSTANT VARCHAR2(30) := 'load_deal';
9024: l_api_version CONSTANT NUMBER := 1.0;
9025:
9026: CURSOR c_hdr_full_uv(p_chr_id OKC_K_HEADERS_ALL_B.ID%TYPE) IS
9027: SELECT *
9028: FROM okl_k_hdrs_full_uv
9029: WHERE chr_id = p_chr_id;
9030:

Line 9033: CURSOR c_hdr_full_v(p_chr_id OKC_K_HEADERS_ALL_B.ID%TYPE) IS

9029: WHERE chr_id = p_chr_id;
9030:
9031: l_hdr_uv_rec c_hdr_full_uv%ROWTYPE;
9032:
9033: CURSOR c_hdr_full_v(p_chr_id OKC_K_HEADERS_ALL_B.ID%TYPE) IS
9034: SELECT *
9035: FROM okl_k_headers_full_v
9036: WHERE id = p_chr_id;
9037:

Line 9040: CURSOR c_okc_hdr(p_chr_id OKC_K_HEADERS_ALL_B.ID%TYPE) IS

9036: WHERE id = p_chr_id;
9037:
9038: l_hdr_rec c_hdr_full_v%ROWTYPE;
9039:
9040: CURSOR c_okc_hdr(p_chr_id OKC_K_HEADERS_ALL_B.ID%TYPE) IS
9041: SELECT contract_number
9042: FROM okc_k_headers_all_b
9043: WHERE id = p_chr_id;
9044:

Line 9042: FROM okc_k_headers_all_b

9038: l_hdr_rec c_hdr_full_v%ROWTYPE;
9039:
9040: CURSOR c_okc_hdr(p_chr_id OKC_K_HEADERS_ALL_B.ID%TYPE) IS
9041: SELECT contract_number
9042: FROM okc_k_headers_all_b
9043: WHERE id = p_chr_id;
9044:
9045: --Bug# 12425605
9046: CURSOR c_bill_to_site(p_site_use_id NUMBER) IS