APPS.OKL_VAR_INT_CATCHUP_PVT dependencies on OKL_STRM_TYPE_V

Line 318: l_stream_type_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE;

314: l_total_interest_billed NUMBER := 0;
315: l_principal_adjusted NUMBER := 0;
316: -- l_catchup_settlement_code OKL_K_RATE_PARAMS.catchup_settlement_code%TYPE;
317: l_invoice_amt NUMBER := 0;
318: l_stream_type_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE;
319: l_invoice_id NUMBER;
320: l_principal_balance_tbl OKL_VARIABLE_INTEREST_PVT.principal_balance_tbl_typ;
321: l_total_asset_val NUMBER := 0;
322: l_principal_balance NUMBER := 0;

Line 378: FROM okl_strm_type_v sty_prin_pmt,

374: AND stm_prin_pmt.kle_id = cp_kle_id;
375:
376: CURSOR principal_adjustment_csr (cp_khr_id NUMBER, cp_start_date DATE, cp_due_date DATE, cp_kle_id NUMBER) IS
377: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
378: FROM okl_strm_type_v sty_prin_pmt,
379: okl_streams_v stm_prin_pmt,
380: okl_strm_elements_v sel_prin_pmt
381: WHERE stm_prin_pmt.khr_id = cp_khr_id
382: AND stm_prin_pmt.id = sel_prin_pmt.stm_id