APPS.OKL_CS_LC_CONTRACT_PVT dependencies on OKL_STREAMS

Line 131: okl_streams stm,

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'
135: AND stm.active_yn = 'Y'

Line 177: ,okl_streams stm

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
181: AND stm.say_code = 'CURR'

Line 198: okl_streams stm,

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
202: AND stm.sty_id = sty.id

Line 594: okl_streams stm,

590: FROM okc_k_lines_b kle,
591: okc_line_styles_b lse,
592: okc_k_items ite,
593: okl_strm_type_b sty1,
594: okl_streams stm,
595: okl_strm_type_b sty2,
596: okl_strm_elements ste
597: WHERE kle.chr_id = p_contract_id
598: AND lse.id = kle.lse_id

Line 1837: okl_streams str

1833: IS
1834: SELECT COUNT(1) payment_remaining
1835: FROM OKL_STRM_TYPE_v STYT,
1836: okl_strm_elements sele,
1837: okl_streams str
1838: WHERE sele.stm_id = str.id
1839: AND str.sty_id = styt.id
1840: AND str.say_code = 'CURR'
1841: AND STR.ACTIVE_YN = 'Y'