APPS.OKL_VAR_INT_FLOAT_FACTOR_PVT dependencies on OKC_K_LINES_B

Line 36: l_line_id OKC_K_LINES_B.id%TYPE;

32: l_stream_type_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE;
33: l_invoice_amt NUMBER := 0;
34: l_formula_id OKL_FORMULAE_V.id%TYPE;
35: l_formula_name OKL_FORMULAE_V.name%TYPE;
36: l_line_id OKC_K_LINES_B.id%TYPE;
37: l_stream_element_date DATE;
38: l_invoice_id NUMBER;
39: l_stream_element_id OKL_STRM_ELEMENTS_V.id%TYPE;
40: var_int_float_factor_failed EXCEPTION;

Line 50: FROM okc_k_headers_b chrb, okc_k_lines_b cleb,

46:
47: Cursor asset_billed_streams_csr (p_contract_id NUMBER, p_from_date DATE, p_to_date DATE) IS
48: SELECT chrb.id contract_id, cleb.id kle_id,
49: selb.stream_element_date, selb.amount amount
50: FROM okc_k_headers_b chrb, okc_k_lines_b cleb,
51: okc_line_styles_b lseb, okl_strm_type_b styb,
52: okl_strm_elements selb, okl_streams stmb,
53: okc_statuses_b sts
54: WHERE cleb.dnz_chr_id = chrb.id