APPS.OKL_QA_CHECK_PUB dependencies on OKC_K_HEADERS_B

Line 30: FROM OKC_K_HEADERS_B

26: CURSOR khr_sts_csr (p_chr_id IN NUMBER) is
27: SELECT STS_CODE,
28: SCS_CODE,
29: CONTRACT_NUMBER
30: FROM OKC_K_HEADERS_B
31: WHERE ID = p_chr_id;
32: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
33: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%Type;
34: l_khr_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

Line 32: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;

28: SCS_CODE,
29: CONTRACT_NUMBER
30: FROM OKC_K_HEADERS_B
31: WHERE ID = p_chr_id;
32: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
33: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%Type;
34: l_khr_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
35:
36: CURSOR check_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

Line 33: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%Type;

29: CONTRACT_NUMBER
30: FROM OKC_K_HEADERS_B
31: WHERE ID = p_chr_id;
32: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
33: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%Type;
34: l_khr_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
35:
36: CURSOR check_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
37: SELECT count(1)

Line 34: l_khr_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

30: FROM OKC_K_HEADERS_B
31: WHERE ID = p_chr_id;
32: l_khr_sts OKC_K_HEADERS_B.STS_CODE%TYPE;
33: l_khr_scs_code OKC_K_HEADERS_B.SCS_CODE%Type;
34: l_khr_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
35:
36: CURSOR check_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
37: SELECT count(1)
38: FROM okl_rbk_selected_contract

Line 45: FROM OKC_K_HEADERS_B

41: l_mrbk NUMBER;
42:
43: CURSOR chr_qcl_csr (p_chr_id IN NUMBER) is
44: SELECT 'Y'
45: FROM OKC_K_HEADERS_B
46: WHERE ID = p_chr_id
47: AND QCL_ID IS NOT NULL;
48: l_qcl_yn VARCHAR2(1) := null;
49: