APPS.MSD_DEM_COLLECT_RETURN_HISTORY dependencies on DBA_OBJECTS

Line 342: FROM dba_objects

338:
339: CURSOR c_get_dm_schema --jarora
340: IS
341: SELECT owner
342: FROM dba_objects
343: WHERE owner = owner
344: AND object_type = 'TABLE'
345: AND object_name = 'MDP_MATRIX'
346: ORDER BY created desc;

Line 652: SELECT count(1) into x_table_present FROM dba_objects WHERE owner = owner AND object_type = 'TABLE' AND object_name = 'MSD_DEM_RETURN_HISTORY_ERR';

648: EXECUTE IMMEDIATE x_sql;
649: END IF;
650:
651: /* Delete RH ERR table */ -- bug#7486714
652: SELECT count(1) into x_table_present FROM dba_objects WHERE owner = owner AND object_type = 'TABLE' AND object_name = 'MSD_DEM_RETURN_HISTORY_ERR';
653: IF (x_table_present > 0 AND x_dem_schema IS NOT NULL) THEN
654: x_sql := 'TRUNCATE TABLE ' || x_dest_table ||'_ERR' ;
655: msd_dem_common_utilities.log_debug ('Trn sql - ' || x_sql);
656: EXECUTE IMMEDIATE x_sql;