APPS.OKL_DEAL_CHARGES_PVT dependencies on OKC_K_LINES_B

Line 19: TYPE asset_rec_type IS RECORD (fin_asset_id OKC_K_LINES_B.id%TYPE,

15: G_API_VERSION CONSTANT NUMBER := 1.0;
16: G_SCOPE CONSTANT VARCHAR2(4) := '_PVT';
17: -------------------------------------------------------------------------------------------------
18:
19: TYPE asset_rec_type IS RECORD (fin_asset_id OKC_K_LINES_B.id%TYPE,
20: amount OKL_K_LINES.amount%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,

Line 24: cleb_cov_asset_id OKC_K_LINES_B.id%TYPE,

20: amount OKL_K_LINES.amount%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:

Line 83: FROM okc_k_lines_b cleb_fin,

79: SELECT cleb_fin.id fin_asset_id,
80: clet_fin.name asset_number,
81: clet_fin.item_description description,
82: NVL(kle_fin.oec,0) oec
83: FROM okc_k_lines_b cleb_fin,
84: okc_k_lines_tl clet_fin,
85: okl_k_lines kle_fin,
86: okc_line_styles_b lse_fin,
87: okc_statuses_b sts

Line 101: FROM okc_k_lines_b cleb_cov_asset,

97:
98: CURSOR c_term_cov_asset_lines(p_chr_id IN NUMBER,
99: p_cle_id IN NUMBER) is
100: SELECT SUM(NVL(kle_cov_asset.capital_amount,kle_cov_asset.amount)) amount
101: FROM okc_k_lines_b cleb_cov_asset,
102: okl_k_lines kle_cov_asset
103: WHERE cleb_cov_asset.dnz_chr_id = p_chr_id
104: AND cleb_cov_asset.cle_id = p_cle_id
105: AND cleb_cov_asset.sts_code = 'TERMINATED'

Line 113: FROM okc_k_lines_b cov_ast_cle,

109: p_cle_id IN NUMBER,
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

Line 125: l_cle_id OKC_K_LINES_B.id%TYPE;

121:
122: l_term_lines_cov_asset_amt NUMBER;
123: i NUMBER := 0;
124: l_chr_id OKC_K_HEADERS_B.id%TYPE;
125: l_cle_id OKC_K_LINES_B.id%TYPE;
126: l_amount NUMBER := 0;
127: l_oec_total NUMBER := 0;
128: l_assoc_amount NUMBER;
129: l_assoc_total NUMBER := 0;