DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_LOAN_TRMNT_PVT dependencies on OKL_STRM_ELEMENTS

Line 3582: FROM okl_strm_elements_v sel,

3578: -- get acceleration till date
3579:
3580: CURSOR get_accel_till_csr (c_khr_id IN NUMBER, c_accrual_sty_id IN NUMBER) IS
3581: SELECT max(stream_element_date) accelerate_till_date
3582: FROM okl_strm_elements_v sel,
3583: okl_streams stm
3584: where SEL.STM_ID = STM.ID
3585: and STM.STY_ID = c_accrual_sty_id
3586: and STM.khr_id = c_khr_id

Line 4825: ,okl_strm_elements ste

4821: FROM okl_streams stm
4822: ,okl_strm_type_b sty
4823: ,okc_k_lines_b kle
4824: ,okc_statuses_b kls
4825: ,okl_strm_elements ste
4826: WHERE stm.khr_id = p_khr_id
4827: AND stm.active_yn = 'Y'
4828: AND stm.say_code = 'CURR'
4829: AND ste.stm_id = stm.id