DBA Data[Home] [Help]

APPS.DDR_ETL_UTIL_PKG dependencies on DBA_DEPENDENCIES

Line 1042: FROM dba_dependencies dep

1038: v_schema VARCHAR2(30) := 'APPS';
1039:
1040: CURSOR c1(p_mv_name VARCHAR2) IS
1041: SELECT dep.name, dep.referenced_name
1042: FROM dba_dependencies dep
1043: WHERE 1=1
1044: AND ((dep.referenced_name<> p_exclude_1 OR p_exclude_1 IS NULL) AND
1045: (dep.referenced_name <> p_exclude_2 OR p_exclude_2 IS NULL) AND
1046: (dep.referenced_name <> p_exclude_3 OR p_exclude_3 IS NULL)