APPS.MSD_DEM_COLLECT_CURRENCY dependencies on MSD_DEM_ENTITIES_INUSE

Line 39: FROM msd_dem_entities_inuse

35: l_schema_name VARCHAR2(200);
36:
37: CURSOR verify_entities_inuse IS
38: SELECT 1
39: FROM msd_dem_entities_inuse
40: WHERE internal_name = p_currency_code
41: and ebs_entity = 'Currency';
42:
43: type c_get_new_currency_real_value IS ref CURSOR;

Line 124: ' select table_name from msd_dem_entities_inuse where ebs_entity = ''Currency'')' ||

120: ' select distinct real_value_id from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_INDEX') || ') ' ||
121: ' and real_table in ' ||
122: ' (select real_table from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'REAL_VALUES') || ' where real_table like ''EBSCURRENCY%''' ||
123: ' minus ' ||
124: ' select table_name from msd_dem_entities_inuse where ebs_entity = ''Currency'')' ||
125: ' and rownum < 2';
126: msd_dem_common_utilities.log_debug(l_stmt_new_currency_real_value);
127: -- syenamar
128:

Line 143: l_stmt := 'insert into msd_dem_entities_inuse(

139: END IF;
140:
141: CLOSE get_new_currency_real_value;
142:
143: l_stmt := 'insert into msd_dem_entities_inuse(
144: ebs_entity
145: ,demantra_entity
146: ,internal_name
147: ,table_name

Line 231: ' (select display_units_id, :1 from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') || ' du, msd_dem_entities_inuse mdei ' ||

227: -- syenamar
228:
229: l_stmt := 'insert into ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'INDEXES_FOR_UNITS') ||
230: ' (display_units_id, real_value_id) ' ||
231: ' (select display_units_id, :1 from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') || ' du, msd_dem_entities_inuse mdei ' ||
232: ' where mdei.ebs_entity = ''PRL'' and mdei.internal_name = du.display_units)';
233:
234: msd_dem_common_utilities.log_debug(l_stmt);
235: