APPS.OKL_BILL_STATUS_PVT dependencies on OKC_K_HEADERS_B

Line 38: OKC_K_HEADERS_B KHR,

34: and cnsld.sel_id in (SELECT SEL.id
35: -- abindal bug 4529600 start --
36: FROM OKL_STREAMS STM,
37: OKL_STRM_ELEMENTS SEL,
38: OKC_K_HEADERS_B KHR,
39: OKL_STRM_TYPE_B STY
40: -- abindal bug 4529600 end --
41: WHERE KHR.id = c_khr_id
42: AND SEL.stream_element_date <= c_transaction_date

Line 61: OKC_K_HEADERS_B KHR,

57: CURSOR c_last_bill_date(c_khr_id in NUMBER, c_transaction_date in DATE) IS
58: SELECT MAX(SEL.stream_element_date) last_bill_date
59: FROM OKL_STREAMS STM,
60: OKL_STRM_ELEMENTS SEL,
61: OKC_K_HEADERS_B KHR,
62: OKL_STRM_TYPE_V STY
63: WHERE KHR.id = c_khr_id
64: AND SEL.stream_element_date <=c_transaction_date
65: AND KHR.id = STM.khr_id

Line 102: FROM OKC_K_HEADERS_B

98: -- gkhuntet added for Forward port Bug #5488905 Start
99:
100: CURSOR check_cont_typ (cp_khr_id IN NUMBER) IS
101: SELECT ORIG_SYSTEM_SOURCE_CODE
102: FROM OKC_K_HEADERS_B
103: WHERE id = cp_khr_id;
104:
105: -- abindal added this cursor for bug 4291677 -- end
106:

Line 395: okc_k_headers_b hdr,

391: -- Changed c_oks_last_sch_bill_date_10(c_khr_id in NUMBER, c_transaction_date DATE) SQL definition
392: CURSOR c_oks_last_sch_bill_date_10(c_khr_id in NUMBER, c_transaction_date DATE) IS
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

Line 396: okc_k_headers_b oks,

392: CURSOR c_oks_last_sch_bill_date_10(c_khr_id in NUMBER, c_transaction_date DATE) IS
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'

Line 416: okc_k_headers_b hdr,

412: -- Changed c_oks_last_sch_bill_date_9(c_khr_id in NUMBER, c_transaction_date DATE) SQL definition
413: CURSOR c_oks_last_sch_bill_date_9(c_khr_id in NUMBER, c_transaction_date DATE) IS
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,

Line 417: okc_k_headers_b oks,

413: CURSOR c_oks_last_sch_bill_date_9(c_khr_id in NUMBER, c_transaction_date DATE) IS
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