APPS.MSC_PS_SNO_TAB_ANLYZ dependencies on MSC_UTIL

Line 18: 'AND A.OWNER = MSC_UTIL.GET_SCHEMA_NAME(724) '||

14: V_MODEL := 'REFERENCE';
15: V_QUERY_STR1 := 'SELECT DISTINCT A.TABLE_NAME TABLE_NAME ' ||
16: 'FROM DBA_TABLES A, MSC_INT_MODEL_NAVIGATION B '||
17: 'WHERE A.TABLE_NAME = TRIM(UPPER(B.TABLE_NAME)) '||
18: 'AND A.OWNER = MSC_UTIL.GET_SCHEMA_NAME(724) '||
19: 'AND UPPER(B.MODEL) = :V_MODEL ';
20:
21: SELECT TRIM(UPPER(TABLE_NAME)) INTO T_NAME
22: FROM DBA_TABLES

Line 24: AND OWNER = MSC_UTIL.GET_SCHEMA_NAME(724);

20:
21: SELECT TRIM(UPPER(TABLE_NAME)) INTO T_NAME
22: FROM DBA_TABLES
23: WHERE TABLE_NAME = 'MSC_INT_MODEL_NAVIGATION'
24: AND OWNER = MSC_UTIL.GET_SCHEMA_NAME(724);
25:
26: IF T_NAME = 'MSC_INT_MODEL_NAVIGATION'
27: THEN
28: OPEN AnalyzeCur FOR V_QUERY_STR1 USING V_MODEL;

Line 32: EXECUTE IMMEDIATE 'ANALYZE TABLE '||MSC_UTIL.GET_SCHEMA_NAME(724)||'.'||LV_TAB||' DELETE STATISTICS';

28: OPEN AnalyzeCur FOR V_QUERY_STR1 USING V_MODEL;
29: LOOP
30: FETCH AnalyzeCur INTO LV_TAB;
31: EXIT WHEN AnalyzeCur%NOTFOUND;
32: EXECUTE IMMEDIATE 'ANALYZE TABLE '||MSC_UTIL.GET_SCHEMA_NAME(724)||'.'||LV_TAB||' DELETE STATISTICS';
33: END LOOP;
34: COMMIT;
35: END IF;
36: