APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_K_HEADERS_FULL_V

Line 4658: --FROM okl_k_headers_full_v

4654: --Bug#3877032
4655: CURSOR con_type_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
4656: SELECT NVL(okc.orig_system_source_code,'X') orig_system_source_code,
4657: NVL(okl.deal_type,'X') deal_type
4658: --FROM okl_k_headers_full_v
4659: FROM okc_k_headers_b okc,
4660: okl_k_headers okl
4661: WHERE okc.id = p_chr_id
4662: AND okc.id = okl.id;

Line 4669: l_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;

4665: SELECT 'Y'
4666: FROM okl_lessee_as_vendors_uv
4667: WHERE dnz_chr_id = p_chr_id;
4668:
4669: l_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;
4670: l_source OKL_K_HEADERS_FULL_V.ORIG_SYSTEM_SOURCE_CODE%TYPE;
4671: l_loan_yn VARCHAR2(1) := 'N';
4672: l_vendor_present VARCHAR2(1) := 'N';
4673:

Line 4670: l_source OKL_K_HEADERS_FULL_V.ORIG_SYSTEM_SOURCE_CODE%TYPE;

4666: FROM okl_lessee_as_vendors_uv
4667: WHERE dnz_chr_id = p_chr_id;
4668:
4669: l_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;
4670: l_source OKL_K_HEADERS_FULL_V.ORIG_SYSTEM_SOURCE_CODE%TYPE;
4671: l_loan_yn VARCHAR2(1) := 'N';
4672: l_vendor_present VARCHAR2(1) := 'N';
4673:
4674: BEGIN

Line 9120: * OKL_K_HEADERS_FULL_V KHR,

9116: * Cursor l_synd_csr ( chrId NUMBER ) IS
9117: * select kl.dnz_chr_id syndId
9118: * from OKC_K_ITEMS_V ITM,
9119: * OKC_K_LINES_V KL,
9120: * OKL_K_HEADERS_FULL_V KHR,
9121: * OKC_LINE_STYLES_B lse
9122: * where KL.LSE_ID=lse.id
9123: * and lse.lty_code='SHARED'
9124: * AND KL.CHR_ID =KL.DNZ_CHR_ID