Line 155: select data_type from user_synonyms syn, dba_tab_columns col
151: */
152:
153: CURSOR l_get_datatype (c_schema IN FND_ORACLE_USERID.ORACLE_USERNAME%TYPE)
154: IS 155: select data_type from user_synonyms syn, dba_tab_columns col 156: where syn.table_owner = c_schema
157: and syn.synonym_name = 'CSF_M_LOBS_INQ'
158: and col.owner = syn.table_owner
159: and col.table_name = syn.table_name