APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_K_HEADERS_FULL_V

Line 5045: --FROM okl_k_headers_full_v

5041: --Bug#3877032
5042: CURSOR con_type_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
5043: SELECT NVL(okc.orig_system_source_code,'X') orig_system_source_code,
5044: NVL(okl.deal_type,'X') deal_type
5045: --FROM okl_k_headers_full_v
5046: FROM okc_k_headers_b okc,
5047: okl_k_headers okl
5048: WHERE okc.id = p_chr_id
5049: AND okc.id = okl.id;

Line 5056: l_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;

5052: SELECT 'Y'
5053: FROM okl_lessee_as_vendors_uv
5054: WHERE dnz_chr_id = p_chr_id;
5055:
5056: l_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;
5057: l_source OKL_K_HEADERS_FULL_V.ORIG_SYSTEM_SOURCE_CODE%TYPE;
5058: l_loan_yn VARCHAR2(1) := 'N';
5059: l_vendor_present VARCHAR2(1) := 'N';
5060:

Line 5057: l_source OKL_K_HEADERS_FULL_V.ORIG_SYSTEM_SOURCE_CODE%TYPE;

5053: FROM okl_lessee_as_vendors_uv
5054: WHERE dnz_chr_id = p_chr_id;
5055:
5056: l_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;
5057: l_source OKL_K_HEADERS_FULL_V.ORIG_SYSTEM_SOURCE_CODE%TYPE;
5058: l_loan_yn VARCHAR2(1) := 'N';
5059: l_vendor_present VARCHAR2(1) := 'N';
5060:
5061: BEGIN

Line 9541: * OKL_K_HEADERS_FULL_V KHR,

9537: * Cursor l_synd_csr ( chrId NUMBER ) IS
9538: * select kl.dnz_chr_id syndId
9539: * from OKC_K_ITEMS_V ITM,
9540: * OKC_K_LINES_V KL,
9541: * OKL_K_HEADERS_FULL_V KHR,
9542: * OKC_LINE_STYLES_B lse
9543: * where KL.LSE_ID=lse.id
9544: * and lse.lty_code='SHARED'
9545: * AND KL.CHR_ID =KL.DNZ_CHR_ID