APPS.OKL_QA_DATA_INTEGRITY dependencies on OKC_K_HEADERS_ALL_B

Line 1325: l_contract_number OKC_K_HEADERS_ALL_B.CONTRACT_NUMBER%TYPE;

1321: -- gboomina modified for Bug 6329395 - Start
1322: CURSOR c_contract_name ( p_id VARCHAR2 ) IS
1323: SELECT contract_number
1324: FROM okc_k_headers_v WHERE id = p_id;
1325: l_contract_number OKC_K_HEADERS_ALL_B.CONTRACT_NUMBER%TYPE;
1326: -- gboomina modified for Bug 6329395 - End
1327:
1328: -- Bug 5114815
1329: CURSOR contract_start_date_csr(p_id NUMBER) IS

Line 7862: okc_k_headers_all_b b,

7858: CURSOR system_corp_book_csr(p_chr_id NUMBER) IS
7859: SELECT A.ASST_ADD_BOOK_TYPE_CODE,
7860: C.secondary_rep_method secondary_rep_method
7861: FROM okl_system_params_all a,
7862: okc_k_headers_all_b b,
7863: okl_sys_acct_opts_all c
7864: WHERE b.id = p_chr_id
7865: AND b.authoring_org_id = a.org_id
7866: AND c.org_id = a.org_id;