APPS.BSC_MO_DB_PKG dependencies on ALL_TAB_COLUMNS

Line 129: FROM ALL_TAB_COLUMNS

125: AND COLUMN_NAME = columnName;
126:
127: CURSOR cAllTabColumns IS
128: SELECT DATA_TYPE, DATA_LENGTH
129: FROM ALL_TAB_COLUMNS
130: WHERE TABLE_NAME = dimTable
131: AND COLUMN_NAME = columnName
132: AND OWNER = BSC_METADATA_OPTIMIZER_PKG.gBSCSchema;
133:

Line 940: SELECT DATA_LENGTH FROM ALL_TAB_COLUMNS

936: Maestra VARCHAR2(100);
937: l_stmt VARCHAR2(300);
938: l_temp NUMBER ;
939: CURSOR c1 (p1 VARCHAR2) IS
940: SELECT DATA_LENGTH FROM ALL_TAB_COLUMNS
941: WHERE UPPER(TABLE_NAME)= p1
942: AND UPPER(COLUMN_NAME) = 'USER_CODE'
943: AND UPPER(OWNER) = BSC_METADATA_OPTIMIZER_PKG.gBSCSchema;
944: