APPS.OKL_DEAL_CHARGES_PVT dependencies on OKC_K_ITEMS

Line 25: cim_cov_asset_id OKC_K_ITEMS.id%TYPE);

21: asset_number OKC_K_LINES_TL.name%TYPE,
22: description OKC_K_LINES_TL.item_description%TYPE,
23: oec OKL_K_LINES.oec%TYPE,
24: cleb_cov_asset_id OKC_K_LINES_B.id%TYPE,
25: cim_cov_asset_id OKC_K_ITEMS.id%TYPE);
26:
27: TYPE asset_tbl_type IS TABLE OF asset_rec_type INDEX BY BINARY_INTEGER;
28:
29: PROCEDURE delete_fee_service(

Line 114: okc_k_items cov_ast_cim

110: p_fin_ast_id IN NUMBER) IS
111: SELECT cov_ast_cle.id cov_ast_cle_id,
112: cov_ast_cim.id cov_ast_cim_id
113: FROM okc_k_lines_b cov_ast_cle,
114: okc_k_items cov_ast_cim
115: WHERE cov_ast_cle.dnz_chr_id = p_chr_id
116: AND cov_ast_cle.cle_id = p_cle_id
117: AND cov_ast_cim.cle_id = cov_ast_cle.id
118: AND cov_ast_cim.object1_id1 = TO_CHAR(p_fin_ast_id)