APPS.OKL_VAR_INT_REAMORT_PVT dependencies on OKL_K_LINES

Line 6: kle_id OKL_K_LINES.id%TYPE,

2: /* $Header: OKLRVRMB.pls 120.0.12020000.6 2013/02/22 23:04:27 rpillay noship $ */
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:

Line 355: okl_K_lines_full_v kle,

351:
352: Cursor ln_future_rents_csr (p_chr_id NUMBER, p_kle_id NUMBER, p_date DATE, p_advance_or_arrears VARCHAR2 ) IS
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

Line 448: okl_K_lines_full_v kle,

444:
445: Cursor l_chr_income_csr (p_chr_id NUMBER, p_kle_id NUMBER, p_date DATE) IS
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

Line 515: okl_K_lines_full_v kle,

511:
512: Cursor residual_value_csr (p_chr_id IN NUMBER, p_kle_id IN NUMBER) IS
513: SELECT nvl(kle.residual_value,0) Value
514: FROM OKC_LINE_STYLES_B LS,
515: okl_K_lines_full_v kle,
516: okc_statuses_b sts
517: WHERE LS.ID = KLE.LSE_ID
518: AND LS.LTY_CODE ='FREE_FORM1'
519: AND KLE.DNZ_CHR_ID = p_chr_id --289326506849179644190030423574805590144

Line 1635: l_line_id_buf okl_k_lines.id%type := -1;

1631: FROM okl_k_headers_full_v
1632: WHERE id = p_contract_id;
1633: -- End by prasjain bug# 6142095
1634: --start | 19-May-08 cklee fixed Bug 7043360 |
1635: l_line_id_buf okl_k_lines.id%type := -1;
1636: --end | 19-May-08 cklee fixed Bug 7043360 |
1637:
1638: CURSOR c_get_child_esg_trx_number( p_contract_id IN NUMBER
1639: ,p_trx_number IN NUMBER )