APPS.OKL_UBB_PVT dependencies on OKL_STRM_ELEMENTS

Line 596: OKL_STRM_ELEMENTS_V SEL,

592: and til.id = tld.til_id_details
593: and tai.description in ('Regular Stream Billing')
594: and cnsld.sel_id in (SELECT SEL.id
595: FROM OKL_STREAMS_V STM,
596: OKL_STRM_ELEMENTS_V SEL,
597: OKC_K_HEADERS_V KHR,
598: OKL_STRM_TYPE_V STY
599: WHERE KHR.id = c_khr_id
600: AND SEL.stream_element_date <= c_transaction_date

Line 615: OKL_STRM_ELEMENTS_V SEL,

611: /*
612: CURSOR c_last_sch_bill_date(c_khr_id in NUMBER, c_transaction_date DATE) IS
613: SELECT max(SEL.stream_element_date) last_sche_bill_date, sel.id
614: FROM OKL_STREAMS_V STM,
615: OKL_STRM_ELEMENTS_V SEL,
616: OKC_K_HEADERS_V KHR,
617: OKL_STRM_TYPE_B STY
618: WHERE KHR.id = c_khr_id
619: AND SEL.stream_element_date <= c_transaction_date

Line 635: OKL_STRM_ELEMENTS_V SEL,

631: CURSOR c_last_sch_bill_date(c_khr_id in NUMBER, c_transaction_date DATE) IS
632: SELECT sel.id stream_id,
633: sel.stream_element_date last_sche_bill_date
634: FROM OKL_STREAMS_V STM,
635: OKL_STRM_ELEMENTS_V SEL,
636: OKL_STRM_TYPE_V STY
637: WHERE sel.stream_element_date = (SELECT max(SEL.stream_element_date) last_sche_bill_date
638: FROM OKL_STREAMS_V STM,
639: OKL_STRM_ELEMENTS_V SEL,

Line 639: OKL_STRM_ELEMENTS_V SEL,

635: OKL_STRM_ELEMENTS_V SEL,
636: OKL_STRM_TYPE_V STY
637: WHERE sel.stream_element_date = (SELECT max(SEL.stream_element_date) last_sche_bill_date
638: FROM OKL_STREAMS_V STM,
639: OKL_STRM_ELEMENTS_V SEL,
640: OKC_K_HEADERS_V KHR,
641: OKL_STRM_TYPE_V STY
642: WHERE KHR.id = c_khr_id
643: AND SEL.stream_element_date <= c_transaction_date

Line 928: l_ste_amount okl_strm_elements.amount%type;

924: l_trx_type okl_trx_ar_invoices_v.try_id%TYPE;
925: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE;
926:
927: l_curr_code okc_k_headers_b.currency_code%TYPE;
928: l_ste_amount okl_strm_elements.amount%type;
929:
930:
931: l_line_number okl_txl_ar_inv_lns_v.line_number%TYPE;
932: l_detail_number okl_txd_ar_ln_dtls_v.line_detail_number%TYPE;