APPS.MSD_DEM_COMMON_UTILITIES dependencies on DBA_OBJECTS

Line 399: FROM dba_objects

395:
396: CURSOR c_get_dm_schema
397: IS
398: SELECT owner
399: FROM dba_objects
400: WHERE owner = owner
401: AND object_type = 'TABLE'
402: AND object_name = 'MDP_MATRIX'
403: ORDER BY created desc;

Line 2332: FROM dba_objects

2328: )
2329: IS
2330: CURSOR c_check_expview(schema_owner varchar2) IS
2331: SELECT object_name
2332: FROM dba_objects
2333: WHERE owner = upper(schema_owner)
2334: AND object_type = 'MATERIALIZED VIEW'
2335: AND object_name = 'BIEO_OBI_MV'
2336: ORDER BY created DESC;

Line 2340: FROM dba_objects

2336: ORDER BY created DESC;
2337:
2338: CURSOR c_check_table IS
2339: SELECT object_name,owner
2340: FROM dba_objects
2341: WHERE owner = owner
2342: AND object_type = 'TABLE'
2343: AND object_name = 'MSD_DEM_BIEO_OBI_MV_DUMMY'
2344: ORDER BY created DESC;