DBA Data[Home] [Help]

APPS.IEM_TAG_KEY_PVT dependencies on IEM_EMAILPROC_RULES

Line 82: from iem_tag_keys a, iem_emailproc_rules b

78: from iem_tag_keys a, iem_route_class_rules b
79: where a.tag_key_id=p_tagKey_ids_tbl(i) and upper('IEMS'||a.tag_id) = UPPER(b.key_type_code);
80:
81: select count(*) into l_emailproc_count
82: from iem_tag_keys a, iem_emailproc_rules b
83: where a.tag_key_id=p_tagKey_ids_tbl(i) and upper('IEMS'||a.tag_id) = UPPER(b.key_type_code);
84:
85: if (l_route_count > 0 ) or (l_class_count > 0 ) or ( l_emailproc_count > 0 ) then
86: select tag_name into l_tag_name from iem_tag_keys where tag_key_id = p_tagKey_ids_tbl(i);