APPS.MSC_UTIL dependencies on DUAL

Line 1114: l_sql := 'select 1 from dual@'||p_dblink;

1110: l_sql varchar2(2000);
1111: l_state boolean := TRUE;
1112: Begin
1113: begin
1114: l_sql := 'select 1 from dual@'||p_dblink;
1115: execute immediate(l_sql);
1116: exception
1117: when too_many_rows then
1118: null;

Line 1372: FROM DUAL;

1368:
1369: BEGIN
1370: SELECT NVL(TO_NUMBER(FND_PROFILE.VALUE('MSC_COLLECTION_WINDOW_FOR_TP_CHANGES')),0)
1371: INTO v_msc_tp_coll_window
1372: FROM DUAL;
1373: EXCEPTION
1374: WHEN OTHERS THEN
1375: v_msc_tp_coll_window := 0;
1376: END ;

Line 1534: FROM Dual)

1530: FROM msc_coll_snapshots_v
1531: WHERE mview_name <> 'ALL SNAPSHOTS'
1532: UNION /*Old Mviews that need to be dropped*/
1533: Select 'BOM_CTO_ORDER_DMD_SN',msc_util.G_BOM_SCHEMA
1534: FROM Dual)
1535: loop
1536: BEGIN
1537: lv_sql:='DROP MATERIALIZED VIEW '||I.mview_owner||'.'||i.mview_name;
1538: EXECUTE IMMEDIATE lv_sql;