65: okl_strm_type_v sty,
66: okc_k_headers_b khr,
67: okl_k_headers khl,
68: okc_k_lines_b kle,
69: okc_statuses_b khs,
70: okc_statuses_b kls
71: WHERE ste.amount <> 0
72: AND stm.id = ste.stm_id
73: AND stm.kle_id = p_kle_id
66: okc_k_headers_b khr,
67: okl_k_headers khl,
68: okc_k_lines_b kle,
69: okc_statuses_b khs,
70: okc_statuses_b kls
71: WHERE ste.amount <> 0
72: AND stm.id = ste.stm_id
73: AND stm.kle_id = p_kle_id
74: AND sty.id = stm.sty_id
96: okl_strm_type_v sty,
97: okc_k_headers_b khr,
98: okl_k_headers khl,
99: okc_k_lines_b kle,
100: okc_statuses_b khs,
101: okc_statuses_b kls
102: WHERE ste.amount <> 0
103: AND stm.id = ste.stm_id
104: AND ste.date_billed IS NOT NULL
97: okc_k_headers_b khr,
98: okl_k_headers khl,
99: okc_k_lines_b kle,
100: okc_statuses_b khs,
101: okc_statuses_b kls
102: WHERE ste.amount <> 0
103: AND stm.id = ste.stm_id
104: AND ste.date_billed IS NOT NULL
105: AND stm.kle_id = p_kle_id