[Home] [Help]
1115: l_residual_value NUMBER := 0;
1116:
1117: Cursor residual_value_csr (p_chr_id IN NUMBER, p_kle_id IN NUMBER) IS
1118: SELECT nvl(kle.residual_value,0) Value
1119: FROM OKC_LINE_STYLES_B LS,
1120: okl_K_lines_full_v kle,
1121: okc_statuses_b sts
1122: WHERE LS.ID = KLE.LSE_ID
1123: AND LS.LTY_CODE ='FREE_FORM1'
1183:
1184: Cursor loan_asset_cost_csr (p_chr_id IN NUMBER) IS
1185: select sum(okl_line.capital_amount) asset_cost
1186: from okc_k_lines_b okc_line,
1187: okc_line_styles_b style,
1188: okl_k_lines okl_line
1189: where okc_line.chr_id = p_chr_id --276779267018378275653765386722943545472
1190: and okc_line.lse_id = style.id
1191: and style.lty_code = 'FREE_FORM1'
1402: FA_BOOKS.book_type_code BOOK_TYPE_CODE
1403: from FA_BOOKS ,
1404: FA_BOOK_CONTROLS,
1405: OKC_K_LINES_B LINES,
1406: OKC_LINE_STYLES_B STYLE,
1407: OKC_K_ITEMS KITEM
1408: where FA_BOOKS.asset_id = KITEM.OBJECT1_ID1
1409: and LINES.DNZ_CHR_ID = p_chr_id --291511068054787299132375269533568315520
1410: and LINES.cle_id = p_kle_id
11883: Cursor asset_billed_streams_csr (p_contract_id NUMBER, p_from_date DATE, p_to_date DATE) IS
11884: SELECT chrb.id contract_id, cleb.id kle_id,
11885: selb.stream_element_date, selb.amount amount
11886: FROM okc_k_headers_b chrb, okc_k_lines_b cleb,
11887: okc_line_styles_b lseb, okl_strm_type_b styb,
11888: okl_strm_elements selb, okl_streams stmb
11889: WHERE cleb.dnz_chr_id = chrb.id
11890: AND cleb.chr_id = chrb.id
11891: AND chrb.id = p_contract_id