APPS.OKL_AM_CALC_QUOTE_STREAM_PVT dependencies on OKL_STRM_TYPE_B

Line 190: okl_strm_type_b sty,

186: cp_quote_eff_date DATE) IS
187: SELECT stm.kle_id contract_line_id,
188: stm.sty_id stream_type_id
189: FROM okl_streams stm,
190: okl_strm_type_b sty,
191: okc_k_lines_b kle,
192: okc_statuses_b kls,
193: okc_line_styles_b lse,
194: okl_strm_elements ste -- SECHAWLA 21-APR-03 2925120 :Added this table

Line 228: okl_strm_type_b sty,

224: okc_k_lines_b cle,
225: okl_k_lines_v kle,
226: okc_line_styles_b lse,
227: okl_streams stm,
228: okl_strm_type_b sty,
229: okl_strm_elements ste -- SECHAWLA 21-APR-03 2925120 :Added this table
230: WHERE ite.object1_id1 = cp_cle_id
231: AND cle.id = ite.cle_id
232: AND lse.id = cle.lse_id

Line 446: okl_strm_type_b sty

442: stm.sty_id stream_type_id,
443: SUM (ste.amount) amount_due
444: FROM okl_streams stm,
445: okl_strm_elements ste,
446: okl_strm_type_b sty
447: WHERE stm.khr_id = cp_chr_id
448: AND stm.kle_id IS NULL
449: AND stm.active_yn = 'Y'
450: AND stm.say_code = 'CURR'

Line 474: okl_strm_type_b sty,

470: stm.sty_id stream_type_id,
471: SUM (ste.amount) amount_due
472: FROM okl_streams stm,
473: okl_strm_elements ste,
474: okl_strm_type_b sty,
475: okc_k_lines_b kle,
476: okc_statuses_b kls,
477: okc_line_styles_b lse
478: WHERE stm.khr_id = cp_chr_id

Line 508: okl_strm_type_b sty

504: stm.sty_id stream_type_id,
505: SUM (ste.amount) amount_due
506: FROM okl_streams stm,
507: okl_strm_elements ste,
508: okl_strm_type_b sty
509: WHERE stm.khr_id = cp_chr_id
510: AND stm.kle_id = cp_cle_id
511: AND stm.active_yn = 'Y'
512: AND stm.say_code = 'CURR'

Line 544: okl_strm_type_b sty,

540: FROM okc_k_items ite,
541: okc_k_lines_b kle,
542: okc_line_styles_b lse,
543: okl_streams stm,
544: okl_strm_type_b sty,
545: okl_strm_elements ste
546: WHERE ite.object1_id1 = to_char(cp_cle_id) -- rmunjulu bug 5129653 need to_char as object1_id1 can be alphanumeric
547: AND kle.id = ite.cle_id
548: AND lse.id = kle.lse_id