DBA Data[Home] [Help]

APPS.OKL_RELEASE_PVT dependencies on OKL_STRM_ELEMENTS_V

Line 3954: FROM okl_strm_elements_v sel

3950: p_release_date IN DATE)
3951: IS
3952: SELECT stream_element_date,
3953: amount
3954: FROM okl_strm_elements_v sel
3955: WHERE sel.stm_id = p_stm_id
3956: AND stream_element_date < p_release_date
3957: ORDER BY stream_element_date DESC;
3958:

Line 4255: FROM okl_strm_elements_v sel

4251: CURSOR unamort_idc_exp_csr(p_stm_id IN NUMBER,
4252: p_release_date IN DATE)
4253: IS
4254: SELECT SUM(amount) amount
4255: FROM okl_strm_elements_v sel
4256: WHERE sel.stm_id = p_stm_id
4257: AND stream_element_date >= p_release_date;
4258:
4259: unamort_idc_exp_rec unamort_idc_exp_csr%ROWTYPE;

Line 4266: FROM okl_strm_elements_v sel

4262: p_release_date IN DATE)
4263: IS
4264: SELECT stream_element_date,
4265: amount
4266: FROM okl_strm_elements_v sel
4267: WHERE sel.stm_id = p_stm_id
4268: AND stream_element_date < p_release_date
4269: ORDER BY stream_element_date DESC;
4270: