172: l_from_date || ' to ' || l_to_date);
173: SELECT To_Char(To_Date(l_from_date, 'dd-mm-yy hh24:mi:ss'),
174: 'dd-mon-yy hh24:mi:ss')
175: INTO l_pub_dt
176: FROM dual;
177: SELECT To_Char(To_Date(l_to_date, 'dd-mm-yy hh24:mi:ss'),
178: 'dd-mon-yy hh24:mi:ss')
179: INTO l_pub_dt_to
180: FROM dual;
176: FROM dual;
177: SELECT To_Char(To_Date(l_to_date, 'dd-mm-yy hh24:mi:ss'),
178: 'dd-mon-yy hh24:mi:ss')
179: INTO l_pub_dt_to
180: FROM dual;
181: l_where_clause := l_where_clause ||
182: ' AND hdr.batch_creation_date >= To_Date( ''' ||
183: l_pub_dt || ''' ,''dd-mon-yy hh24:mi:ss''' || ' )';
184: l_where_clause := l_where_clause ||