APPS.OKL_BILL_STATUS_PVT dependencies on OKC_K_LINES_B

Line 236: FROM okc_k_lines_b

232:
233: -- get contract line id's
234: CURSOR c_okl_line_items(c_khr_id IN NUMBER) IS
235: SELECT id, lse_id
236: FROM okc_k_lines_b
237: WHERE dnz_chr_id = c_khr_id
238: AND orig_system_source_code <> 'OKL_SPLIT';
239:
240: -----------------------------------------------------------------------------------------

Line 265: -- OKC_K_LINES_B KLE,

261: AND tai.description IN ('Regular Stream Billing')
262: AND EXISTS ( SELECT '1'
263: FROM OKL_STREAMS STM,
264: OKL_STRM_ELEMENTS SEL,
265: -- OKC_K_LINES_B KLE,
266: OKL_STRM_TYPE_B STY
267: WHERE SEL.ID = cnsld.SEL_ID
268: AND SEL.stream_element_date <= TRUNC(c_transaction_date)
269: -- AND KLE.ID = STM.KLE_ID

Line 281: FROM okc_k_lines_b kle

277: 'PRINCIPAL_PAYMENT', 'LOAN_PAYMENT',
278: 'FLOAT_FACTOR_ADJUSTMENT')
279: AND SEL.amount > 0
280: AND STM.KLE_ID IN ( SELECT kle.id
281: FROM okc_k_lines_b kle
282: WHERE kle.dnz_chr_id = c_khr_id
283: CONNECT BY PRIOR kle.orig_system_id1 = kle.id
284: START WITH kle.id = c_kle_id ))
285: GROUP BY tai.description;

Line 312: -- OKC_K_LINES_B KLE,

308: AND RACTRL.description IN ('Regular Stream Billing')
309: AND EXISTS ( SELECT '1'
310: FROM OKL_STREAMS STM,
311: OKL_STRM_ELEMENTS SEL,
312: -- OKC_K_LINES_B KLE,
313: OKL_STRM_TYPE_B STY
314: WHERE SEL.ID = RACTRL.SEL_ID
315: AND SEL.stream_element_date <= TRUNC(c_transaction_date)
316: -- AND KLE.ID = STM.KLE_ID

Line 328: FROM okc_k_lines_b kle

324: 'PRINCIPAL_PAYMENT', 'LOAN_PAYMENT',
325: 'FLOAT_FACTOR_ADJUSTMENT')
326: AND SEL.amount > 0
327: AND STM.KLE_ID IN ( SELECT kle.id
328: FROM okc_k_lines_b kle
329: WHERE kle.dnz_chr_id = c_khr_id
330: CONNECT BY PRIOR kle.orig_system_id1 = kle.id
331: START WITH kle.id = c_kle_id ))
332: GROUP BY RACTRL.description;

Line 397: okc_k_lines_b oks_line,

393: select max(schd.date_to_interface) last_sche_bill_date
394: from okc_k_rel_objs rel,
395: okc_k_headers_b hdr,
396: okc_k_headers_b oks,
397: okc_k_lines_b oks_line,
398: OKS_LEVEL_ELEMENTS_V schd, OKS_STREAM_LEVELS_B strm
399: where hdr.id = c_khr_id
400: and rty_code = 'OKLSRV'
401: and rel.jtot_object1_code = 'OKL_SERVICE'

Line 418: okc_k_lines_b oks_line,

414: select max(schd.date_to_interface) last_sche_bill_date
415: from okc_k_rel_objs rel,
416: okc_k_headers_b hdr,
417: okc_k_headers_b oks,
418: okc_k_lines_b oks_line,
419: OKS_LEVEL_ELEMENTS_V schd,
420: okc_rules_b rules,
421: okc_rule_groups_b rgp
422: where hdr.id = c_khr_id