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:
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;
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: