2094: hr_operating_units hou,
2095: okc_k_lines_b kle,
2096: --added for evergreen change request 08_nov_2005
2097: okc_line_styles_b lse,
2098: okc_statuses_b khs,
2099: okc_statuses_b kls,
2100: okl_party_payment_hdr pph
2101: WHERE trunc(ste.stream_element_date) >=
2102: trunc(NVL (p_from_date, ste.stream_element_date))
2095: okc_k_lines_b kle,
2096: --added for evergreen change request 08_nov_2005
2097: okc_line_styles_b lse,
2098: okc_statuses_b khs,
2099: okc_statuses_b kls,
2100: okl_party_payment_hdr pph
2101: WHERE trunc(ste.stream_element_date) >=
2102: trunc(NVL (p_from_date, ste.stream_element_date))
2103: AND trunc(ste.stream_element_date) <=
2168: okc_k_lines_b kle,
2169: okc_k_lines_b sub_kle,
2170: --added for evergreen change request 08_nov_2005
2171: okc_line_styles_b lse,
2172: okc_statuses_b khs,
2173: okc_statuses_b kls,
2174: okl_party_payment_hdr pph
2175: WHERE trunc(ste.stream_element_date) >=
2176: trunc(NVL (p_from_date, ste.stream_element_date))
2169: okc_k_lines_b sub_kle,
2170: --added for evergreen change request 08_nov_2005
2171: okc_line_styles_b lse,
2172: okc_statuses_b khs,
2173: okc_statuses_b kls,
2174: okl_party_payment_hdr pph
2175: WHERE trunc(ste.stream_element_date) >=
2176: trunc(NVL (p_from_date, ste.stream_element_date))
2177: AND trunc(ste.stream_element_date) <=