APPS.BSC_DIM_TPLATE dependencies on USER_OBJECTS

Line 107: From USER_OBJECTS

103: -- create Account Type dimension table
104: l_object_type := 'BSC_D_TYPE_OF_ACCOUNT';
105: Select count(*)
106: Into l_count
107: From USER_OBJECTS
108: Where OBJECT_NAME = l_object_type;
109:
110: if (l_count <> 0) then
111: l_sql_stmt := 'Drop Table BSC_D_TYPE_OF_ACCOUNT';

Line 160: From USER_OBJECTS

156: -- Create Input table
157: l_object_type := 'BSC_DI_2';
158: Select count(*)
159: Into l_count
160: From USER_OBJECTS
161: Where OBJECT_NAME = l_object_type;
162:
163: if (l_count <> 0) then
164: l_sql_stmt := 'Drop Table BSC_DI_2';

Line 197: From USER_OBJECTS

193:
194: l_object_type := 'BSC_D_ACCOUNT';
195: Select count(*)
196: Into l_count
197: From USER_OBJECTS
198: Where OBJECT_NAME = l_object_type;
199:
200: if (l_count <> 0) then
201: l_sql_stmt := 'Drop Table BSC_D_ACCOUNT';

Line 253: From USER_OBJECTS

249: -- Create Input table
250: l_object_type := 'BSC_DI_0' ;
251: Select count(*)
252: Into l_count
253: From USER_OBJECTS
254: Where OBJECT_NAME = l_object_type ;
255:
256: if (l_count <> 0) then
257: l_sql_stmt := 'Drop Table BSC_DI_0';

Line 292: From USER_OBJECTS

288:
289: l_object_type := 'BSC_D_SUBACCOUNT' ;
290: Select count(*)
291: Into l_count
292: From USER_OBJECTS
293: Where OBJECT_NAME = l_object_type ;
294:
295: if (l_count <> 0) then
296: l_sql_stmt := 'Drop Table BSC_D_SUBACCOUNT';

Line 349: From USER_OBJECTS

345:
346: l_object_type := 'BSC_DI_1' ;
347: Select count(*)
348: Into l_count
349: From USER_OBJECTS
350: Where OBJECT_NAME = l_object_type;
351:
352: if (l_count <> 0) then
353: l_sql_stmt := 'Drop Table BSC_DI_1';

Line 386: From USER_OBJECTS

382:
383: l_object_type := 'BSC_D_PROJECT' ;
384: Select count(*)
385: Into l_project_count
386: From USER_OBJECTS
387: Where OBJECT_NAME = l_object_type;
388:
389: if (l_project_count <> 0) then
390: l_sql_stmt := 'Drop Table BSC_D_PROJECT';

Line 437: From USER_OBJECTS

433: -- Create Input table
434: l_object_type := 'BSC_DI_3' ;
435: Select count(*)
436: Into l_count
437: From USER_OBJECTS
438: Where OBJECT_NAME = l_object_type;
439:
440: if (l_count <> 0) then
441: l_sql_stmt := 'Drop Table BSC_DI_3';