APPS.OKL_VAR_INT_REAMORT_PVT dependencies on OKL_K_LINES_FULL_V

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