APPS.OKL_QA_CHECK_PUB dependencies on OKC_K_HEADERS_V

Line 36: CURSOR check_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

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
39: WHERE khr_id = p_chr_id
40: AND NVL(status,'NEW') = 'UNDER REVISION';