APPS.OKL_VARIABLE_INTEREST_PVT dependencies on OKC_K_LINES_B

Line 1186: from okc_k_lines_b okc_line,

1182: l_asset_cost NUMBER := 0;
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

Line 1405: OKC_K_LINES_B LINES,

1401: FA_BOOKS.cost ASSET_COST,
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

Line 11872: l_line_id OKC_K_LINES_B.id%TYPE;

11868: l_stream_type_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE;
11869: l_invoice_amt NUMBER := 0;
11870: l_formula_id OKL_FORMULAE_V.id%TYPE;
11871: l_formula_name OKL_FORMULAE_V.name%TYPE;
11872: l_line_id OKC_K_LINES_B.id%TYPE;
11873: l_stream_element_date DATE;
11874: l_invoice_id NUMBER;
11875: l_stream_element_id OKL_STRM_ELEMENTS_V.id%TYPE;
11876: var_int_float_factor_failed EXCEPTION;

Line 11886: FROM okc_k_headers_b chrb, okc_k_lines_b cleb,

11882:
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