APPS.OKL_DEAL_PAYMENTS_PVT dependencies on OKC_K_ITEMS

Line 47: okc_k_items cim_fee

43: CURSOR l_fee_name_csr(p_chr_id IN NUMBER,
44: p_cle_id IN NUMBER) IS
45: SELECT styt.name
46: FROM okl_strm_type_tl styt,
47: okc_k_items cim_fee
48: WHERE cim_fee.cle_id = p_cle_id
49: AND cim_fee.dnz_chr_id = p_chr_id
50: AND cim_fee.jtot_object1_code = 'OKL_STRMTYP'
51: AND styt.id = cim_fee.object1_id1

Line 58: okc_k_items cim_svc

54: CURSOR l_service_name_csr(p_chr_id IN NUMBER,
55: p_cle_id IN NUMBER) IS
56: SELECT msit.description
57: FROM mtl_system_items_tl msit,
58: okc_k_items cim_svc
59: WHERE cim_svc.cle_id = p_cle_id
60: AND cim_svc.dnz_chr_id = p_chr_id
61: AND cim_svc.jtot_object1_code = 'OKX_SERVICE'
62: AND msit.inventory_item_id = cim_svc.object1_id1

Line 125: okc_k_items cim_cov_asset

121: CURSOR l_asset_num_cov_asset_csr(p_cle_id IN NUMBER,
122: p_chr_id IN NUMBER) IS
123: SELECT clet_fin.name
124: FROM okc_k_lines_tl clet_fin,
125: okc_k_items cim_cov_asset
126: WHERE cim_cov_asset.cle_id = p_cle_id
127: AND cim_cov_asset.dnz_chr_id = p_chr_id
128: AND cim_cov_asset.jtot_object1_code = 'OKX_COVASST'
129: AND clet_fin.id = cim_cov_asset.object1_id1

Line 192: okc_k_items cim_cov_asset

188: SELECT clet_fin.id,
189: clet_fin.name,
190: clet_fin.item_description
191: FROM okc_k_lines_tl clet_fin,
192: okc_k_items cim_cov_asset
193: WHERE cim_cov_asset.cle_id = p_cle_id
194: AND cim_cov_asset.dnz_chr_id = p_chr_id
195: AND cim_cov_asset.jtot_object1_code = 'OKX_COVASST'
196: AND clet_fin.id = cim_cov_asset.object1_id1