APPS.BSC_MIGREATION_UI dependencies on DUAL

Line 18: l_sql := 'Select sysdate from dual@' ||p_dblink_name;

14: BEGIN
15:
16: Execute immediate p_dblink_sql;
17:
18: l_sql := 'Select sysdate from dual@' ||p_dblink_name;
19:
20: execute immediate l_sql;
21:
22: p_create_status := 0;

Line 64: select sysdate into l_dummy from dual;

60: l_sql varchar2(1000);
61: l_dummy date;
62: BEGIN
63: ---if(p_dblink_name == 'BSC_SRC_DBLINK_UI')
64: select sysdate into l_dummy from dual;
65: --rollback; -- we have to see if we can remove this roll back
66:
67: begin
68: EXECUTE IMMEDIATE 'ALTER SESSION CLOSE DATABASE LINK '|| p_dblink_name;