APPS.OKL_VAR_INT_REAMORT_PVT dependencies on OKC_STATUSES_B

Line 356: okc_statuses_b sts,

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
360: WHERE kle.dnz_chr_id = p_chr_id

Line 449: okc_statuses_b sts,

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
453: WHERE kle.dnz_chr_id = p_chr_id

Line 516: okc_statuses_b sts

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
520: AND KLE.id = p_kle_id

Line 1568: , OKC_STATUSES_B STS

1564: --Added by bkatraga for bug 14811647
1565: CURSOR check_asset_term_csr(p_kle_id OKC_K_LINES_B.ID%TYPE) IS
1566: SELECT 'Y'
1567: FROM OKC_K_LINES_B CLE
1568: , OKC_STATUSES_B STS
1569: WHERE CLE.ID = p_kle_id
1570: AND CLE.LSE_ID = 33
1571: AND STS.CODE = CLE.STS_CODE
1572: AND STS.STE_CODE = 'TERMINATED';