DBA Data[Home] [Help]

APPS.OKL_VAR_INT_CATCHUP_PVT dependencies on OKL_STREAMS_V

Line 379: okl_streams_v stm_prin_pmt,

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
383: AND sel_prin_pmt.stream_element_date BETWEEN cp_start_date AND cp_due_date