99:
100:
101: select max(day)
102: into l_uwq_max_date
103: from bix_dm_uwq_agent_sum;
104:
105: SELECT MAX(collect_end_date) INTO l_collect_max_date
106: FROM bix_dm_collect_log
107: WHERE object_name = 'BIX_DM_UWQ_GROUP_SUM';
203:
204:
205: select max(day)
206: into l_uwq_max_date
207: from bix_dm_uwq_agent_sum;
208:
209: SELECT MAX(collect_end_date) INTO l_collect_max_date
210: FROM bix_dm_collect_log
211: WHERE object_name = 'BIX_DM_UWQ_GROUP_SUM';
243:
244:
245: select max(day)
246: into l_uwq_max_date
247: from bix_dm_uwq_agent_sum;
248:
249: SELECT MAX(collect_end_date) INTO l_collect_max_date
250: FROM bix_dm_collect_log
251: WHERE object_name = 'BIX_DM_UWQ_GROUP_SUM';