APPS.OKL_PROP_TAX_ADJ_PVT dependencies on OKL_STRM_ELEMENTS

Line 63: FROM okl_strm_elements ste,

59: -- Extract all actual property tax billable
60: ------------------------------------------------------------
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,

Line 94: FROM okl_strm_elements ste,

90: CURSOR est_property_tax_csr ( p_khr_id IN NUMBER, p_kle_id IN NUMBER ) IS
91: SELECT SUM(AMOUNT)
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,

Line 230: FROM okl_strm_elements

226: -- Max Line Number
227: ------------------------------------------------------------
228: CURSOR max_line_num_csr (p_stm_id NUMBER) IS
229: SELECT max(se_line_number)
230: FROM okl_strm_elements
231: WHERE stm_id = p_stm_id;
232:
233: ------------------------------------------------------------
234: -- Operating Unit