APPS.OKL_LTE_CHRG_PVT dependencies on OKL_STREAMS_V

Line 41: l_stm_id OKL_STREAMS_V.ID%TYPE;

37: l_amt_due_remaining AR_PAYMENT_SCHEDULES_ALL.AMOUNT_DUE_REMAINING%type;
38: l_due_date AR_PAYMENT_SCHEDULES_ALL.DUE_DATE%type;
39: l_khr_id OKL_CNSLD_AR_STRMS_B.KHR_ID%type;
40: l_sty_id OKL_STRM_TYPE_V.ID%TYPE;
41: l_stm_id OKL_STREAMS_V.ID%TYPE;
42: l_late_stm_id OKL_STREAMS_V.ID%TYPE;
43: l_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;
44: l_amount NUMBER;
45: l_stream_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE;

Line 42: l_late_stm_id OKL_STREAMS_V.ID%TYPE;

38: l_due_date AR_PAYMENT_SCHEDULES_ALL.DUE_DATE%type;
39: l_khr_id OKL_CNSLD_AR_STRMS_B.KHR_ID%type;
40: l_sty_id OKL_STRM_TYPE_V.ID%TYPE;
41: l_stm_id OKL_STREAMS_V.ID%TYPE;
42: l_late_stm_id OKL_STREAMS_V.ID%TYPE;
43: l_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;
44: l_amount NUMBER;
45: l_stream_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE;
46: l_sec_rec_inv_id OKL_CNSLD_AR_STRMS_V.ID%TYPE;

Line 480: FROM okl_streams_v stm

476: -- cursor for AR invoices
477: CURSOR l_AR_stream_csr(cp_khr_id IN NUMBER
478: ,cp_sty_id IN NUMBER) IS
479: SELECT stm.id
480: FROM okl_streams_v stm
481: WHERE stm.khr_id = cp_khr_id
482: AND stm.sty_id = cp_sty_id
483: AND stm.say_code = 'CURR'
484: AND stm.active_yn = 'Y';

Line 491: FROM okl_streams_v stm

487: CURSOR l_cons_stream_csr(cp_khr_id IN NUMBER
488: ,cp_kle_id IN NUMBER
489: ,cp_sty_id IN NUMBER) IS
490: SELECT stm.id
491: FROM okl_streams_v stm
492: WHERE stm.khr_id = cp_khr_id
493: AND nvl(stm.kle_id, -99) = nvl(cp_kle_id, -99)
494: AND stm.sty_id = cp_sty_id
495: AND stm.say_code = 'CURR'

Line 501: FROM okl_streams_v stm

497: -- second cursor for consolidated invoices
498: CURSOR l_stream_csr(cp_khr_id IN NUMBER
499: ,cp_sty_id IN NUMBER) IS
500: SELECT stm.id
501: FROM okl_streams_v stm
502: WHERE stm.khr_id = cp_khr_id
503: AND stm.sty_id = cp_sty_id
504: AND stm.say_code = 'CURR'
505: AND stm.active_yn = 'Y';