DBA Data[Home] [Help]

APPS.OKL_QA_DATA_INTEGRITY dependencies on OKC_K_HEADERS_ALL_B

Line 1307: l_contract_number OKC_K_HEADERS_ALL_B.CONTRACT_NUMBER%TYPE;

1303: -- gboomina modified for Bug 6329395 - Start
1304: CURSOR c_contract_name ( p_id VARCHAR2 ) IS
1305: SELECT contract_number
1306: FROM okc_k_headers_v WHERE id = p_id;
1307: l_contract_number OKC_K_HEADERS_ALL_B.CONTRACT_NUMBER%TYPE;
1308: -- gboomina modified for Bug 6329395 - End
1309:
1310: --Added end_date by bkatraga for bug 13478101
1311: -- Bug 5114815

Line 8279: okc_k_headers_all_b b,

8275: CURSOR system_corp_book_csr(p_chr_id NUMBER) IS
8276: SELECT A.ASST_ADD_BOOK_TYPE_CODE,
8277: C.secondary_rep_method secondary_rep_method
8278: FROM okl_system_params_all a,
8279: okc_k_headers_all_b b,
8280: okl_sys_acct_opts_all c
8281: WHERE b.id = p_chr_id
8282: AND b.authoring_org_id = a.org_id
8283: AND c.org_id = a.org_id;