DBA Data[Home] [Help]

APPS.OKL_RELEASE_PVT dependencies on OKL_STRM_ELEMENTS_V

Line 4014: FROM okl_strm_elements_v sel

4010: p_release_date IN DATE)
4011: IS
4012: SELECT stream_element_date,
4013: amount
4014: FROM okl_strm_elements_v sel
4015: WHERE sel.stm_id = p_stm_id
4016: AND stream_element_date < p_release_date
4017: ORDER BY stream_element_date DESC;
4018:

Line 4315: FROM okl_strm_elements_v sel

4311: CURSOR unamort_idc_exp_csr(p_stm_id IN NUMBER,
4312: p_release_date IN DATE)
4313: IS
4314: SELECT SUM(amount) amount
4315: FROM okl_strm_elements_v sel
4316: WHERE sel.stm_id = p_stm_id
4317: AND stream_element_date >= p_release_date;
4318:
4319: unamort_idc_exp_rec unamort_idc_exp_csr%ROWTYPE;

Line 4326: FROM okl_strm_elements_v sel

4322: p_release_date IN DATE)
4323: IS
4324: SELECT stream_element_date,
4325: amount
4326: FROM okl_strm_elements_v sel
4327: WHERE sel.stm_id = p_stm_id
4328: AND stream_element_date < p_release_date
4329: ORDER BY stream_element_date DESC;
4330: