[Home] [Help]
61: CURSOR actual_property_tax_csr ( p_khr_id IN NUMBER, p_kle_id IN NUMBER ) IS
62: SELECT NVL(SUM(ste.amount),0) amount
63: FROM okl_strm_elements ste,
64: okl_streams stm,
65: okl_strm_type_v sty,
66: okc_k_headers_b khr,
67: okl_k_headers khl,
68: okc_k_lines_b kle,
69: okc_statuses_b khs,
92: FROM (
93: SELECT NVL(SUM(ste.amount),0) amount
94: FROM okl_strm_elements ste,
95: okl_streams stm,
96: okl_strm_type_v sty,
97: okc_k_headers_b khr,
98: okl_k_headers khl,
99: okc_k_lines_b kle,
100: okc_statuses_b khs,
119: SELECT NVL(SUM(til.amount),0) amount
120: FROM okc_k_headers_b khr,
121: okl_trx_ar_invoices_v tai,
122: okl_txl_ar_inv_lns_v til,
123: okl_strm_type_v sty
124: WHERE khr.id = p_khr_id
125: AND tai.khr_id = khr.id
126: AND tai.id = til.tai_id
127: AND tai.qte_id IS NOT NULL
184: ------------------------------------------------------------
185: CURSOR c_sty_count_csr ( p_khr_id NUMBER, p_kle_id NUMBER, p_sty_name VARCHAR2 ) IS
186: SELECT count(*)
187: FROM okl_streams stm,
188: okl_strm_type_v sty
189: WHERE stm.khr_id = p_khr_id
190: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
191: AND stm.sty_id = sty.id
192: AND stm.say_code = 'CURR'
204: -- Stream Type Cursor
205: ------------------------------------------------------------
206: CURSOR sty_csr IS
207: SELECT id
208: FROM okl_strm_type_v
209: WHERE STREAM_TYPE_PURPOSE = 'ADJUSTED_PROPERTY_TAX';
210:
211: ------------------------------------------------------------
212: -- Get stm_id of Adjusted Property Tax record
213: ------------------------------------------------------------
214: CURSOR c_stm_id_csr ( p_khr_id NUMBER, p_kle_id NUMBER, p_sty_name VARCHAR2 ) IS
215: SELECT stm.id
216: FROM okl_streams stm,
217: okl_strm_type_v sty
218: WHERE stm.khr_id = p_khr_id
219: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
220: AND stm.sty_id = sty.id
221: AND stm.say_code = 'CURR'