APPS.MSC_UTIL dependencies on DUAL

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

852: l_sql varchar2(2000);
853: l_state boolean := TRUE;
854: Begin
855: begin
856: l_sql := 'select 1 from dual@'||p_dblink;
857: execute immediate(l_sql);
858: exception
859: when too_many_rows then
860: null;

Line 1116: FROM DUAL;

1112:
1113: BEGIN
1114: SELECT NVL(TO_NUMBER(FND_PROFILE.VALUE('MSC_COLLECTION_WINDOW_FOR_TP_CHANGES')),0)
1115: INTO v_msc_tp_coll_window
1116: FROM DUAL;
1117: EXCEPTION
1118: WHEN OTHERS THEN
1119: v_msc_tp_coll_window := 0;
1120: END ;