DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKL_STRM_ELEMENTS_V

Line 6447: FROM okl_strm_elements_v sel,

6443: /*
6444: -- -- rmunjulu bug 4416094
6445: CURSOR get_accel_till_csr(p_khr_id IN NUMBER, p_pretax_sty_id IN NUMBER, p_rentaccrual_sty_id IN NUMBER, p_interestincome_sty_id IN NUMBER) IS
6446: SELECT MAX(stream_element_date)
6447: FROM okl_strm_elements_v sel,
6448: okl_streams stm
6449: WHERE sel.stm_id = stm.id AND
6450: stm.sty_id IN (p_pretax_sty_id, p_rentaccrual_sty_id,
6451: p_interestincome_sty_id) AND stm.khr_id = p_khr_id;

Line 6459: FROM okl_strm_elements_v sel,

6455: -- Bug#7248153 - rbruno - changed - Start
6456:
6457: CURSOR get_accel_till_csr(p_khr_id IN NUMBER, p_sty_id IN NUMBER) IS
6458: SELECT MAX(stream_element_date)
6459: FROM okl_strm_elements_v sel,
6460: okl_streams stm
6461: WHERE sel.stm_id = stm.id AND
6462: stm.sty_id = p_sty_id AND stm.khr_id = p_khr_id;
6463: