APPS.OKL_VAR_INT_FLOAT_FACTOR_PVT dependencies on OKL_FORMULAE_V

Line 34: l_formula_id OKL_FORMULAE_V.id%TYPE;

30: l_api_name CONSTANT VARCHAR2(30) := 'VARIABLE_INTEREST_FLOAT_FACTOR';
31: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
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;

Line 35: l_formula_name OKL_FORMULAE_V.name%TYPE;

31: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
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;

Line 44: FROM okl_formulae_v fml

40: var_int_float_factor_failed EXCEPTION;
41:
42: Cursor formula_name_csr (p_formula_id NUMBER) IS
43: SELECT fml.name
44: FROM okl_formulae_v fml
45: WHERE fml.id = p_formula_id;
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,