APPS.EDW_SOURCE_INSTANCES_PKG dependencies on DUAL

Line 425: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS

421: X_INSTANCE_CODE in VARCHAR2
422: ) IS
423: dummy NUMBER;
424: BEGIN
425: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
426: (SELECT 1 FROM edw_push_detail_log
427: WHERE INSTANCE_CODE = X_INSTANCE_CODE);
428:
429: EXCEPTION

Line 501: DBMS_SQL.PARSE(cid, 'SELECT sysdate FROM dual@'||X_WAREHOUSE_TO_INSTANCE_LINK, dbms_sql.native);

497: BEGIN
498: edw_misc_util.globalNamesOff;
499:
500: cid := DBMS_SQL.open_cursor;
501: DBMS_SQL.PARSE(cid, 'SELECT sysdate FROM dual@'||X_WAREHOUSE_TO_INSTANCE_LINK, dbms_sql.native);
502: dbms_sql.define_column(cid, 1, remote_date);
503: v_ret_code:=dbms_sql.execute(cid);
504: if dbms_sql.fetch_rows(cid)<>0 then
505: dbms_sql.column_value(cid, 1, remote_date);

Line 531: FROM dual;

527: v_ret_code := dbms_sql.execute(v_cursor_id);
528: dbms_sql.close_cursor(v_cursor_id);
529:
530: SELECT userenv('LANG') INTO v_source_lang
531: FROM dual;
532:
533: v_sql_stmt := 'insert into EDW_LOCAL_INSTANCE_TL@' ||
534: x_warehouse_to_instance_link ||
535: '(INSTANCE_CODE, NAME, DESCRIPTION, CREATION_DATE, CREATED_BY,