APPS.OKL_PROPERTY_TAX_STATEMENT_PVT dependencies on OKC_K_HEADERS_B

Line 68: CURSOR c_cntrct_asst_id_csr(cp_cont_num_from okc_k_headers_b.contract_number%TYPE,

64: p_asset_name_from IN VARCHAR2,
65: p_asset_name_to IN VARCHAR2)
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,

Line 69: cp_cont_num_to okc_k_headers_b.contract_number%TYPE,

65: p_asset_name_to IN VARCHAR2)
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

Line 74: FROM okc_k_headers_b chr,

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 ,
76: okc_line_styles_b ls
77: WHERE chr.contract_number BETWEEN NVL(cp_cont_num_from,chr.contract_number) AND NVL(cp_cont_num_to,chr.contract_number)
78: AND asset.chr_id = chr.id

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 100: okc_k_headers_b khr,

96: decode(date_billed,NULL,0,ste.amount) amount
97: FROM okl_strm_elements ste,
98: okl_streams stm,
99: okl_strm_type_v sty,
100: okc_k_headers_b khr,
101: okl_k_headers khl,
102: okl_k_lines_full_v asset,
103: okc_line_styles_b ls,
104: okl_property_tax_v ptv,

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 218: okc_k_headers_b khr,

214: ste.amount amount
215: FROM okl_strm_elements ste,
216: okl_streams stm,
217: okl_strm_type_v sty,
218: okc_k_headers_b khr,
219: okl_k_headers khl,
220: okl_k_lines_full_v asset,
221: okc_line_styles_b ls,
222: okc_k_lines_b kle,

Line 261: l_cont_id OKC_K_HEADERS_B.id%TYPE DEFAULT NULL;

257: --local variables
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;