APPS.OKL_CS_LC_CONTRACT_PVT dependencies on OKL_STRM_ELEMENTS

Line 130: FROM okl_strm_elements sel,

126: --Begin-varangan-bug#5009351
127:
128: CURSOR cr_next_payment_date(c_contract_id IN NUMBER) IS
129: SELECT MIN(sel.stream_element_date)
130: FROM okl_strm_elements sel,
131: okl_streams stm,
132: okl_strm_type_v sty
133: WHERE stm.sty_id = sty.id
134: AND stm.say_code = 'CURR'

Line 176: FROM okl_strm_elements sel

172: -- replaced type name with purpose, enhancements for user defined streams bug
173: -- 3924303
174: CURSOR next_due_date(c_contract_id NUMBER,c_stream_type_purpose VARCHAR2) IS
175: SELECT MIN(sel.stream_element_date)
176: FROM okl_strm_elements sel
177: ,okl_streams stm
178: ,okl_strm_type_v sty
179: WHERE sty.stream_type_purpose = c_stream_type_purpose
180: AND stm.sty_id = sty.id

Line 197: FROM okl_strm_elements sel,

193: -- 3924303
194: CURSOR next_due_amount(c_next_due_date DATE,c_contract_id NUMBER
195: ,c_stream_type_purpose VARCHAR2) IS
196: SELECT NVL(sum(sel.amount),0)
197: FROM okl_strm_elements sel,
198: okl_streams stm,
199: okl_strm_type_v sty
200: --Bug 4084405
201: WHERE sty.stream_type_purpose = c_stream_type_purpose

Line 558: okl_strm_elements ste

554: okc_k_items ite,
555: okl_strm_type_b sty1,
556: okl_streams stm,
557: okl_strm_type_b sty2,
558: okl_strm_elements ste
559: WHERE kle.chr_id = p_contract_id
560: AND lse.id = kle.lse_id
561: AND lse.lty_code = 'FEE'
562: AND ite.cle_id = kle.id

Line 1798: okl_strm_elements sele,

1794: CURSOR c_get_unbilled_payment(p_contract_id IN NUMBER,p_cle_id IN NUMBER)
1795: IS
1796: SELECT COUNT(1) payment_remaining
1797: FROM OKL_STRM_TYPE_v STYT,
1798: okl_strm_elements sele,
1799: okl_streams str
1800: WHERE sele.stm_id = str.id
1801: AND str.sty_id = styt.id
1802: AND str.say_code = 'CURR'