APPS.OKL_BILL_STATUS_PVT dependencies on OKL_STREAMS_V

Line 82: FROM OKL_STREAMS_V STM,

78: -- abindal added this cursor for bug 4291677 -- start
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

Line 155: FROM OKL_STREAMS_V STM,

151: --Bug 5050707: SEL.id not being used , putting distinct would restrict the processing of the duplicate link history stream id
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

Line 175: FROM OKL_STREAMS_V

171:
172: -- drill down each SEL_ID until original retreived ...
173: CURSOR c_last_bill_date_3 (c_sel_id in NUMBER) IS
174: SELECT LINK_HIST_STREAM_ID
175: FROM OKL_STREAMS_V
176: WHERE ID = c_sel_id;
177:
178: /* -- rmunjulu R12 Fixes -- commented this cursor out and redone below
179: -- fetch original sel_ids from stm_id ...

Line 182: FROM OKL_STREAMS_V STM,

178: /* -- rmunjulu R12 Fixes -- commented this cursor out and redone below
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

Line 207: FROM OKL_STREAMS_V STM,

203:
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

Line 339: FROM OKL_STREAMS_V STM,

335:
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

Line 359: FROM OKL_STREAMS_V STM,

355:
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,

Line 363: FROM OKL_STREAMS_V STM,

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,
365: OKC_K_HEADERS_V KHR,
366: OKL_STRM_TYPE_V STY
367: WHERE KHR.id = c_khr_id