eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_PROPERTY_TAX_STATEMENT_PVT dependencies on OKX_ASSET_LINES_V

Line 70: cp_asset_name_from okx_asset_lines_v.name%TYPE,

66: IS
67: --Cursor to get the Contract id and Asset id from the given contract number and asset number range
68: CURSOR c_cntrct_asst_id_csr(cp_cont_num_from okc_k_headers_b.contract_number%TYPE,
69: cp_cont_num_to okc_k_headers_b.contract_number%TYPE,
70: cp_asset_name_from okx_asset_lines_v.name%TYPE,
71: cp_asset_name_to okx_asset_lines_v.name%TYPE) IS
72: SELECT asset.chr_id CHR_ID,
73: asset.id KLE_ID
74: FROM okc_k_headers_b chr,

Line 71: cp_asset_name_to okx_asset_lines_v.name%TYPE) IS

67: --Cursor to get the Contract id and Asset id from the given contract number and asset number range
68: CURSOR c_cntrct_asst_id_csr(cp_cont_num_from okc_k_headers_b.contract_number%TYPE,
69: cp_cont_num_to okc_k_headers_b.contract_number%TYPE,
70: cp_asset_name_from okx_asset_lines_v.name%TYPE,
71: cp_asset_name_to okx_asset_lines_v.name%TYPE) IS
72: SELECT asset.chr_id CHR_ID,
73: asset.id KLE_ID
74: FROM okc_k_headers_b chr,
75: okl_k_lines_full_v asset ,

Line 86: CURSOR c_act_ppt_tax(cp_khr_id OKC_K_HEADERS_B.ID%TYPE,cp_kle_id OKX_ASSET_LINES_V.ID1%TYPE) IS

82:
83:
84: -- Cursor to get the actual property tax.
85: --fix for bug 4003861
86: CURSOR c_act_ppt_tax(cp_khr_id OKC_K_HEADERS_B.ID%TYPE,cp_kle_id OKX_ASSET_LINES_V.ID1%TYPE) IS
87: SELECT khr.contract_number,
88: asset.name,
89: ptv.JURSDCTN_NAME ,
90: trunc(stream_element_date) lien_date ,

Line 136: CURSOR c_estm_ppt_tax(cp_khr_id OKC_K_HEADERS_B.ID%TYPE,cp_kle_id OKX_ASSET_LINES_V.ID1%TYPE) IS

132: AND kls.code(+) = kle.sts_code
133: AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED');
134:
135: -- Cursor to get the estimated property tax.
136: CURSOR c_estm_ppt_tax(cp_khr_id OKC_K_HEADERS_B.ID%TYPE,cp_kle_id OKX_ASSET_LINES_V.ID1%TYPE) IS
137: SELECT khr.contract_number,
138: asset.name,
139: sty.STREAM_TYPE_PURPOSE ,
140: sty.name STREAM_TYPE,

Line 208: CURSOR c_adjst_ppt_tax(cp_khr_id OKC_K_HEADERS_B.ID%TYPE,cp_kle_id OKX_ASSET_LINES_V.ID1%TYPE) IS

204: AND sty.STREAM_TYPE_PURPOSE = 'AMPRTX';
205:
206: -- Cursor to get the adjusted property tax.
207: --fix for bug 4003861
208: CURSOR c_adjst_ppt_tax(cp_khr_id OKC_K_HEADERS_B.ID%TYPE,cp_kle_id OKX_ASSET_LINES_V.ID1%TYPE) IS
209: SELECT khr.contract_number,
210: asset.name,
211: sty.STREAM_TYPE_PURPOSE ,
212: sty.name STREAM_TYPE,

Line 262: l_asset_id OKX_ASSET_LINES_V.id1%TYPE DEFAULT NULL;

258: l_op_unit HR_OPERATING_UNITS.name%type;
259: l_curr_code VARCHAR2(30) DEFAULT NULL;
260: l_request_id NUMBER DEFAULT 0;
261: l_cont_id OKC_K_HEADERS_B.id%TYPE DEFAULT NULL;
262: l_asset_id OKX_ASSET_LINES_V.id1%TYPE DEFAULT NULL;
263: l_act_amt NUMBER DEFAULT 0;
264: -- added by stmathew
265: l_imp_amt NUMBER DEFAULT 0;
266: