DBA Data[Home] [Help]

APPS.BSC_MO_DB_PKG dependencies on USER_TAB_COLUMNS

Line 123: FROM USER_TAB_COLUMNS

119: Function GetDimKeyDataType(dimTable IN VARCHAR2, columnName IN VARCHAR2, dataLength OUT NOCOPY NUMBER) RETURN VARCHAR2 IS
120: l_stmt VARCHAR2(1000);
121: CURSOR cUserTabColumns IS
122: SELECT DATA_TYPE, DATA_LENGTH
123: FROM USER_TAB_COLUMNS
124: WHERE TABLE_NAME = dimTable
125: AND COLUMN_NAME = columnName;
126:
127: CURSOR cAllTabColumns IS