APPS.IEM_TAG_KEY_PVT dependencies on IEM_ROUTE_RULES

Line 74: from iem_tag_keys a, iem_route_rules b

70: l_route_count := 0;
71: l_class_count := 0;
72:
73: select count(*) into l_route_count
74: from iem_tag_keys a, iem_route_rules b
75: where a.tag_key_id=p_tagKey_ids_tbl(i) and upper('IEMS'||a.tag_id) = UPPER(b.key_type_code);
76:
77: select count(*) into l_class_count
78: from iem_tag_keys a, iem_route_class_rules b