APPS.IEM_SPV_MONITORING_PVT dependencies on IEM_ACCOUNT_ROUTE_CLASS

Line 113: from iem_route_classifications a, iem_account_route_class b

109:
110: l_monitor_index := l_monitor_index + 1;
111:
112: select a.route_classification_id, a.name bulk collect into l_class_id_tbl, l_class_name_tbl
113: from iem_route_classifications a, iem_account_route_class b
114: where a.route_classification_id = b.route_classification_id and b.email_account_id=l_email_account_id_tbl(l_index) order by UPPER(a.name);
115:
116: for i in l_class_id_tbl.FIRST..l_class_id_tbl.LAST LOOP
117: -- Queue statistics