DBA Data[Home] [Help]

APPS.OKL_VAR_INT_CATCHUP_PVT dependencies on OKL_STRM_TYPE_B

Line 345: ,okl_strm_type_b sty

341: SELECT nvl(SUM(nvl(amount, 0)),0) pmt_amt
342: FROM
343: okl_strm_elements sel
344: ,okl_streams str
345: ,okl_strm_type_b sty
346: WHERE sel.stm_id = str.id
347: AND str.khr_id = cp_khr_id
348: AND str.say_code = 'CURR'
349: AND str.active_yn = 'Y'

Line 364: FROM okl_strm_type_b sty_prin_pmt,

360: -- Should not fetch Financed Fee, Rollover Fee or Linked Fee-Asset line level INTEREST_PAYMENT stream amounts
361: -- Bug# 13447258: Support Asset Level calculations
362: CURSOR int_pay_amt_end_date_csr (cp_khr_id NUMBER, cp_start_date DATE, cp_stream_type_purpose VARCHAR2, cp_kle_id NUMBER) IS
363: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
364: FROM okl_strm_type_b sty_prin_pmt,
365: okl_streams stm_prin_pmt,
366: okl_strm_elements sel_prin_pmt
367: WHERE stm_prin_pmt.khr_id = cp_khr_id
368: AND stm_prin_pmt.id = sel_prin_pmt.stm_id