390: -- nikshah -- Bug # 5484903 Fixed,
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
411: -- nikshah -- Bug # 5484903 Fixed,
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,