APPS.OKL_DEAL_CREAT_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 4839: FROM okc_k_headers_all_b

4835: AND rgd_code = p_rgd_code;
4836:
4837: CURSOR c_orig_system_source(p_chr_id NUMBER) IS
4838: SELECT orig_system_source_code
4839: FROM okc_k_headers_all_b
4840: WHERE id = p_chr_id;
4841:
4842: l_tax_schedule_yn VARCHAR2(1);
4843: lp_lahdtx_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;

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

8931: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
8932: l_api_name CONSTANT VARCHAR2(30) := 'load_deal';
8933: l_api_version CONSTANT NUMBER := 1.0;
8934:
8935: CURSOR c_hdr_full_uv(p_chr_id OKC_K_HEADERS_ALL_B.ID%TYPE) IS
8936: SELECT *
8937: FROM okl_k_hdrs_full_uv
8938: WHERE chr_id = p_chr_id;
8939:

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

8938: WHERE chr_id = p_chr_id;
8939:
8940: l_hdr_uv_rec c_hdr_full_uv%ROWTYPE;
8941:
8942: CURSOR c_hdr_full_v(p_chr_id OKC_K_HEADERS_ALL_B.ID%TYPE) IS
8943: SELECT *
8944: FROM okl_k_headers_full_v
8945: WHERE id = p_chr_id;
8946:

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

8945: WHERE id = p_chr_id;
8946:
8947: l_hdr_rec c_hdr_full_v%ROWTYPE;
8948:
8949: CURSOR c_okc_hdr(p_chr_id OKC_K_HEADERS_ALL_B.ID%TYPE) IS
8950: SELECT contract_number
8951: FROM okc_k_headers_all_b
8952: WHERE id = p_chr_id;
8953:

Line 8951: FROM okc_k_headers_all_b

8947: l_hdr_rec c_hdr_full_v%ROWTYPE;
8948:
8949: CURSOR c_okc_hdr(p_chr_id OKC_K_HEADERS_ALL_B.ID%TYPE) IS
8950: SELECT contract_number
8951: FROM okc_k_headers_all_b
8952: WHERE id = p_chr_id;
8953:
8954: CURSOR c_bill_to_site(p_site_use_id NUMBER) IS
8955: SELECT description