APPS.OKL_VAR_INT_FLOAT_FACTOR_PVT dependencies on OKL_STRM_ELEMENTS

Line 39: l_stream_element_id OKL_STRM_ELEMENTS_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;
41:
42: Cursor formula_name_csr (p_formula_id NUMBER) IS
43: SELECT fml.name

Line 52: okl_strm_elements selb, okl_streams stmb,

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
55: AND cleb.chr_id = chrb.id
56: AND chrb.id = p_contract_id