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 485: FROM okl_streams_v stm

481: -- cursor for AR invoices
482: CURSOR l_AR_stream_csr(cp_khr_id IN NUMBER
483: ,cp_sty_id IN NUMBER) IS
484: SELECT stm.id
485: FROM okl_streams_v stm
486: WHERE stm.khr_id = cp_khr_id
487: AND stm.sty_id = cp_sty_id
488: AND stm.say_code = 'CURR'
489: AND stm.active_yn = 'Y';

Line 496: FROM okl_streams_v stm

492: CURSOR l_cons_stream_csr(cp_khr_id IN NUMBER
493: ,cp_kle_id IN NUMBER
494: ,cp_sty_id IN NUMBER) IS
495: SELECT stm.id
496: FROM okl_streams_v stm
497: WHERE stm.khr_id = cp_khr_id
498: AND nvl(stm.kle_id, -99) = nvl(cp_kle_id, -99)
499: AND stm.sty_id = cp_sty_id
500: AND stm.say_code = 'CURR'

Line 506: FROM okl_streams_v stm

502: -- second cursor for consolidated invoices
503: CURSOR l_stream_csr(cp_khr_id IN NUMBER
504: ,cp_sty_id IN NUMBER) IS
505: SELECT stm.id
506: FROM okl_streams_v stm
507: WHERE stm.khr_id = cp_khr_id
508: AND stm.sty_id = cp_sty_id
509: AND stm.say_code = 'CURR'
510: AND stm.active_yn = 'Y';