DBA Data[Home] [Help]

APPS.OKL_VAR_INT_FLOAT_PVT dependencies on OKL_K_LINES

Line 601: l_kle_id OKL_K_LINES.id%TYPE;

597: l_stream_type_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE;
598: i_vir_tbl OKL_VARIABLE_INTEREST_PVT.vir_tbl_type;
599: r_vir_tbl OKL_VARIABLE_INTEREST_PVT.vir_tbl_type;
600: l_stream_element_id OKL_STRM_ELEMENTS_v.id%TYPE;
601: l_kle_id OKL_K_LINES.id%TYPE;
602: l_strm_element_date OKL_STRM_ELEMENTS.stream_element_date%TYPE;
603: l_parent_strm_element_id OKL_STRM_ELEMENTS.id%TYPE;
604: var_int_loan_float_failed EXCEPTION;
605:

Line 640: FROM okl_k_lines_full_v

636: AND sty_prin_pmt.stream_type_purpose = 'VARIABLE_LOAN_PAYMENT';
637:
638: CURSOR contract_line_csr (cp_khr_id NUMBER, cp_due_date DATE) IS
639: SELECT id
640: FROM okl_k_lines_full_v
641: WHERE chr_id = cp_khr_id
642: AND lse_id = OKL_VARIABLE_INTEREST_PVT.G_FIN_LINE_LTY_ID
643: AND nvl(date_terminated, cp_due_date + 1) > cp_due_date
644: ORDER BY id;