APPS.IEM_DBLINK_PVT dependencies on DUAL

Line 136: select CONCAT(l_iem_server_rec.service_name, '@appsto_oo') into l_glname from DUAL;

132: l_v_id := DBMS_SQL.OPEN_CURSOR;
133:
134: IF (p_db_username = 'oo') THEN
135:
136: select CONCAT(l_iem_server_rec.service_name, '@appsto_oo') into l_glname from DUAL;
137:
138: l_search_string := l_iem_server_rec.service_name || '%' || '@appsto_oo';
139: select count(*)into l_link_count from all_db_links where upper(owner)=upper(l_schema_owner) and db_link like UPPER(l_search_string);
140:

Line 155: select CONCAT(l_iem_server_rec.service_name, '@appsto_ora') into l_glname from DUAL;

151: ')))''';
152:
153: ELSIF (p_db_username = 'oraoffice') THEN
154:
155: select CONCAT(l_iem_server_rec.service_name, '@appsto_ora') into l_glname from DUAL;
156:
157: l_search_string := l_iem_server_rec.service_name || '%' || '@appsto_ora';
158: select count(*)into l_link_count from all_db_links where upper(owner)=upper(l_schema_owner) and db_link like UPPER(l_search_string);
159: