APPS.OKL_UBB_PVT dependencies on OKL_STRM_ELEMENTS_V

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