2147: hr_operating_units hou,
2148: okc_k_lines_b kle,
2149: --added for evergreen change request 08_nov_2005
2150: okc_line_styles_b lse,
2151: okc_statuses_b khs,
2152: okc_statuses_b kls,
2153: okl_party_payment_hdr pph
2154: WHERE trunc(ste.stream_element_date) >=
2155: trunc(NVL (p_from_date, ste.stream_element_date))
2148: okc_k_lines_b kle,
2149: --added for evergreen change request 08_nov_2005
2150: okc_line_styles_b lse,
2151: okc_statuses_b khs,
2152: okc_statuses_b kls,
2153: okl_party_payment_hdr pph
2154: WHERE trunc(ste.stream_element_date) >=
2155: trunc(NVL (p_from_date, ste.stream_element_date))
2156: AND trunc(ste.stream_element_date) <=
2221: okc_k_lines_b kle,
2222: okc_k_lines_b sub_kle,
2223: --added for evergreen change request 08_nov_2005
2224: okc_line_styles_b lse,
2225: okc_statuses_b khs,
2226: okc_statuses_b kls,
2227: okl_party_payment_hdr pph
2228: WHERE trunc(ste.stream_element_date) >=
2229: trunc(NVL (p_from_date, ste.stream_element_date))
2222: okc_k_lines_b sub_kle,
2223: --added for evergreen change request 08_nov_2005
2224: okc_line_styles_b lse,
2225: okc_statuses_b khs,
2226: okc_statuses_b kls,
2227: okl_party_payment_hdr pph
2228: WHERE trunc(ste.stream_element_date) >=
2229: trunc(NVL (p_from_date, ste.stream_element_date))
2230: AND trunc(ste.stream_element_date) <=