DBA Data[Home] [Help]

APPS.AZ_PROFILEVALUE_CONVERT_PKG dependencies on USER_TAB_COLUMNS

Line 240: from user_tab_columns col

236: AND col.table_name = syn.table_name
237: AND syn.table_OWNER=L_OWNER
238: union
239: select data_type
240: from user_tab_columns col
241: where col.table_name = P_TBL_NAME
242: AND col.column_name = P_COL_NAME);
243: IF ( L_COL_TYPE IS NULL OR LENGTH(L_COL_TYPE)=0 ) THEN
244: L_COL_TYPE := '';

Line 258: from user_tab_columns col

254: AND col.table_name = syn.table_name
255: AND syn.table_OWNER=L_OWNER
256: union
257: select data_type
258: from user_tab_columns col
259: where col.table_name = P_TBL_NAME
260: AND col.column_name = P_COL_NAME);
261: IF ( L_COL_TYPE IS NULL OR LENGTH(L_COL_TYPE)=0 ) THEN
262: L_COL_TYPE := '';