APPS.OKL_VAR_INT_REAMORT_PVT dependencies on OKL_STRM_ELEMENTS

Line 7: principal_balance OKL_STRM_ELEMENTS.amount%TYPE);

3:
4:
5: TYPE line_principal_rec_type IS RECORD (
6: kle_id OKL_K_LINES.id%TYPE,
7: principal_balance OKL_STRM_ELEMENTS.amount%TYPE);
8:
9: TYPE line_principal_tbl_type is TABLE of line_principal_rec_type INDEX BY BINARY_INTEGER;
10:
11:

Line 357: okl_strm_elements sel,

353: select NVL(sum(sel.amount), 0) amount
354: from
355: okl_K_lines_full_v kle,
356: okc_statuses_b sts,
357: okl_strm_elements sel,
358: okl_streams stm,
359: okl_strm_type_b sty
360: WHERE kle.dnz_chr_id = p_chr_id
361: AND kle.id = p_kle_id

Line 378: FROM okl_strm_elements sele,

374: ln_future_rents_rec ln_future_rents_csr%ROWTYPE;
375:
376: Cursor l_chr_rents_csr (p_chr_id NUMBER, p_kle_id NUMBER, p_date DATE, p_advance_or_arrears VARCHAR2) IS
377: SELECT NVL(SUM(sele.amount),0) amount
378: FROM okl_strm_elements sele,
379: okl_streams str,
380: okl_strm_type_b sty
381: WHERE sele.stm_id = str.id
382: AND str.sty_id = sty.id

Line 450: okl_strm_elements sel,

446: select NVL(sum(sel.amount), 0) amount
447: from
448: okl_K_lines_full_v kle,
449: okc_statuses_b sts,
450: okl_strm_elements sel,
451: okl_streams stm,
452: okl_strm_type_b sty
453: WHERE kle.dnz_chr_id = p_chr_id
454: AND kle.id = p_kle_id