APPS.OKL_BILL_STATUS_PVT dependencies on OKL_STRM_ELEMENTS_V

Line 83: OKL_STRM_ELEMENTS_V SEL,

79: CURSOR c_last_bill_date_import(c_khr_id in NUMBER, c_transaction_date in DATE) IS
80: SELECT --SEL.stream_element_date last_bill_date
81: MAX(SEL.date_billed) last_bill_date
82: FROM OKL_STREAMS_V STM,
83: OKL_STRM_ELEMENTS_V SEL,
84: OKC_K_HEADERS_V KHR,
85: OKL_STRM_TYPE_V STY
86: WHERE KHR.id = c_khr_id
87: AND SEL.stream_element_date <=c_transaction_date

Line 156: OKL_STRM_ELEMENTS_V SEL,

152: --SELECT SEL.ID, STM.LINK_HIST_STREAM_ID
153: SELECT distinct STM.LINK_HIST_STREAM_ID
154: --Bug 5050707:end
155: FROM OKL_STREAMS_V STM,
156: OKL_STRM_ELEMENTS_V SEL,
157: OKC_K_HEADERS_V KHR,
158: OKL_STRM_TYPE_V STY
159: WHERE KHR.id = c_khr_id
160: AND SEL.stream_element_date <= c_transaction_date

Line 183: OKL_STRM_ELEMENTS_V SEL,

179: -- fetch original sel_ids from stm_id ...
180: CURSOR c_last_bill_date_4 (c_stm_id in NUMBER, c_khr_id IN NUMBER,c_transaction_date in DATE) IS
181: SELECT distinct(SEL.ID)
182: FROM OKL_STREAMS_V STM,
183: OKL_STRM_ELEMENTS_V SEL,
184: OKC_K_HEADERS_V KHR,
185: OKL_STRM_TYPE_V STY,
186: okl_cnsld_ar_strms_b cnsld
187: WHERE KHR.id = c_khr_id

Line 208: OKL_STRM_ELEMENTS_V SEL,

204: -- rmunjulu R12 Fixes - redone this cursor
205: CURSOR c_last_bill_date_4 (c_stm_id in NUMBER, c_khr_id IN NUMBER,c_transaction_date in DATE) IS
206: SELECT distinct(SEL.ID)
207: FROM OKL_STREAMS_V STM,
208: OKL_STRM_ELEMENTS_V SEL,
209: OKC_K_HEADERS_V KHR,
210: OKL_STRM_TYPE_V STY,
211: --okl_cnsld_ar_strms_b cnsld
212: okl_txd_ar_ln_dtls_b tld

Line 340: OKL_STRM_ELEMENTS_V SEL,

336: /*
337: CURSOR c_last_sch_bill_date(c_khr_id in NUMBER, c_transaction_date DATE) IS
338: SELECT max(SEL.stream_element_date) last_sche_bill_date, sel.id
339: FROM OKL_STREAMS_V STM,
340: OKL_STRM_ELEMENTS_V SEL,
341: OKC_K_HEADERS_V KHR,
342: OKL_STRM_TYPE_B STY
343: WHERE KHR.id = c_khr_id
344: AND SEL.stream_element_date <= c_transaction_date

Line 360: OKL_STRM_ELEMENTS_V SEL,

356: CURSOR c_last_sch_bill_date(c_khr_id in NUMBER, c_transaction_date DATE) IS
357: SELECT sel.id stream_id,
358: sel.stream_element_date last_sche_bill_date
359: FROM OKL_STREAMS_V STM,
360: OKL_STRM_ELEMENTS_V SEL,
361: OKL_STRM_TYPE_V STY
362: WHERE sel.stream_element_date = (SELECT max(SEL.stream_element_date) last_sche_bill_date
363: FROM OKL_STREAMS_V STM,
364: OKL_STRM_ELEMENTS_V SEL,

Line 364: OKL_STRM_ELEMENTS_V SEL,

360: OKL_STRM_ELEMENTS_V SEL,
361: OKL_STRM_TYPE_V STY
362: WHERE sel.stream_element_date = (SELECT max(SEL.stream_element_date) last_sche_bill_date
363: FROM OKL_STREAMS_V STM,
364: OKL_STRM_ELEMENTS_V SEL,
365: OKC_K_HEADERS_V KHR,
366: OKL_STRM_TYPE_V STY
367: WHERE KHR.id = c_khr_id
368: AND SEL.stream_element_date <= c_transaction_date