APPS.OKL_AM_CALC_QUOTE_STREAM_PVT dependencies on OKC_K_LINES_B

Line 191: okc_k_lines_b kle,

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
195: WHERE stm.khr_id = cp_chr_id

Line 224: okc_k_lines_b cle,

220: SELECT stm.kle_id contract_line_id,
221: stm.sty_id stream_type_id,
222: kle.capital_amount line_payment
223: FROM okc_k_items ite,
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,

Line 253: FROM okc_k_lines_b cle,

249: CURSOR l_total_payments_csr (
250: cp_cle_id NUMBER,
251: cp_link_style VARCHAR2) IS
252: SELECT sum (kle.capital_amount) total_payment
253: FROM okc_k_lines_b cle,
254: okl_k_lines_v kle,
255: okc_line_styles_b lse
256: WHERE cle.cle_id = cp_cle_id
257: AND lse.id = cle.lse_id

Line 475: okc_k_lines_b kle,

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

Line 541: okc_k_lines_b kle,

537: SELECT stm.kle_id contract_line_id,
538: stm.sty_id stream_type_id,
539: SUM (ste.amount) amount_due
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