APPS.OKL_LA_JE_PVT dependencies on OKC_K_HEADERS_B

Line 41: FROM okc_k_headers_b CHR

37:
38: --cursor to check if contract is a re-lease contract
39: CURSOR l_chk_rel_khr_csr (p_chr_id IN Number) IS
40: SELECT 'Y'
41: FROM okc_k_headers_b CHR
42: where chr.ID = p_chr_id
43: AND nvl(chr.orig_system_source_code,'XXXX') = 'OKL_RELEASE';
44:
45: l_rel_khr VARCHAR2(1) DEFAULT 'N';

Line 51: FROM okc_k_headers_b CHR

47:
48: --cursor to check if contract has re-lease assets
49: CURSOR l_chk_rel_ast_csr (p_chr_id IN Number) IS
50: SELECT 'Y'
51: FROM okc_k_headers_b CHR
52: WHERE nvl(chr.orig_system_source_code,'XXXX') <> 'OKL_RELEASE'
53: and chr.ID = p_chr_id
54: AND exists (SELECT '1'
55: FROM OKC_RULES_B rul

Line 144: okc_k_headers_b chr

140: select ct.object1_id1 id
141: from okc_contacts ct,
142: okc_contact_sources csrc,
143: okc_k_party_roles_b pty,
144: okc_k_headers_b chr
145: where ct.cpl_id = pty.id
146: and ct.cro_code = csrc.cro_code
147: and ct.jtot_object1_code = csrc.jtot_object_code
148: and ct.dnz_chr_id = chr.id

Line 161: from okc_k_headers_b

157: l_salesP_rec salesP_csr%ROWTYPE;
158:
159: Cursor custBillTo_csr( chrId NUMBER) IS
160: select bill_to_site_use_id cust_acct_site_id
161: from okc_k_headers_b
162: where id = chrId;
163:
164: /* Rule migration - BTO
165:

Line 282: FROM OKC_K_HEADERS_B

278:
279: --Added by dpsingh for LE uptake
280: CURSOR contract_num_csr (p_ctr_id1 NUMBER) IS
281: SELECT contract_number
282: FROM OKC_K_HEADERS_B
283: WHERE id = p_ctr_id1;
284:
285: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
286: l_legal_entity_id NUMBER;

Line 285: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

281: SELECT contract_number
282: FROM OKC_K_HEADERS_B
283: WHERE id = p_ctr_id1;
284:
285: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
286: l_legal_entity_id NUMBER;
287:
288: --Bug# 5964482
289: l_trxl_del_tbl Okl_trx_contracts_pvt.tclv_tbl_type;