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