APPS.OKL_DEAL_CHARGES_PVT dependencies on OKL_K_LINES

Line 20: amount OKL_K_LINES.amount%TYPE,

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,
24: cleb_cov_asset_id OKC_K_LINES_B.id%TYPE,

Line 23: oec OKL_K_LINES.oec%TYPE,

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,
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;

Line 85: okl_k_lines kle_fin,

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
88: WHERE cleb_fin.dnz_chr_id = p_chr_id
89: AND cleb_fin.chr_id = p_chr_id

Line 102: okl_k_lines kle_cov_asset

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'
106: AND kle_cov_asset.id = cleb_cov_asset.id;