APPS.OKL_CS_LC_CONTRACT_PVT dependencies on OKL_STRM_TYPE_V

Line 132: okl_strm_type_v sty

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'
136: AND sty.billable_yn = 'Y'

Line 178: ,okl_strm_type_v sty

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

Line 199: okl_strm_type_v sty

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

Line 1835: FROM OKL_STRM_TYPE_v STYT,

1831: IS
1832: CURSOR c_get_unbilled_payment(p_contract_id IN NUMBER,p_cle_id IN NUMBER)
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

Line 1860: OKL_STRM_TYPE_v STYT

1856: rul_lasll.rule_information3 periods
1857: FROM OKC_RULE_GROUPS_B RGP_LALEVL,
1858: OKC_RULES_B RUL_LASLH,
1859: OKC_RULES_B RUL_LASLL,
1860: OKL_STRM_TYPE_v STYT
1861: WHERE RGP_LALEVL.RGD_CODE = 'LALEVL'
1862: AND RUL_LASLH.RGP_ID = RGP_LALEVL.ID
1863: AND RUL_LASLH.RULE_INFORMATION_CATEGORY = 'LASLH'
1864: AND RUL_LASLH.DNZ_CHR_ID = RGP_LALEVL.DNZ_CHR_ID