APPS.AZ_PROFILEVALUE_CONVERT_PKG dependencies on DBA_TAB_COLUMNS

Line 231: from dba_tab_columns

227:
228: IF ( L_APP_CODE IS NULL OR LENGTH(L_APP_CODE)=0 ) THEN
229: L_OWNER := GET_TABLEVIEW_OWNER( L_APP_CODE, 'VIEW' ); -- for view, will get 'APPS'
230: SELECT DATA_TYPE into L_COL_TYPE
231: from dba_tab_columns
232: where COLUMN_NAME=P_COL_NAME AND TABLE_NAME=P_TBL_NAME AND OWNER=L_OWNER;
233:
234: IF ( L_COL_TYPE IS NULL OR LENGTH(L_COL_TYPE)=0 ) THEN
235: L_COL_TYPE := '';

Line 240: from dba_tab_columns

236: END IF;
237: ELSE
238: L_OWNER := GET_TABLEVIEW_OWNER( L_APP_CODE, 'TABLE' ); -- for table, get HR, APPLSYS, ...
239: SELECT DATA_TYPE into L_COL_TYPE
240: from dba_tab_columns
241: where COLUMN_NAME=P_COL_NAME AND TABLE_NAME=P_TBL_NAME AND OWNER=L_OWNER;
242:
243: IF ( L_COL_TYPE IS NULL OR LENGTH(L_COL_TYPE)=0 ) THEN
244: L_COL_TYPE := '';