DBA Data[Home] [Help]

APPS.AZ_PROFILEVALUE_CONVERT_PKG dependencies on DBA_TAB_COLUMNS

Line 232: from user_synonyms syn, dba_tab_columns col

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 FROM
231: (SELECT DATA_TYPE
232: from user_synonyms syn, dba_tab_columns col
233: where col.COLUMN_NAME=P_COL_NAME
234: AND syn.synonym_name=P_TBL_NAME
235: AND col.owner = syn.table_owner
236: AND col.table_name = syn.table_name

Line 250: from user_synonyms syn, dba_tab_columns col

246: ELSE
247: L_OWNER := GET_TABLEVIEW_OWNER( L_APP_CODE, 'TABLE' ); -- for table, get HR, APPLSYS, ...
248: SELECT DATA_TYPE into L_COL_TYPE FROM
249: (SELECT DATA_TYPE
250: from user_synonyms syn, dba_tab_columns col
251: where col.COLUMN_NAME=P_COL_NAME
252: AND syn.synonym_name=P_TBL_NAME
253: AND col.owner = syn.table_owner
254: AND col.table_name = syn.table_name