APPS.CSM_LOBS_PKG dependencies on DBA_TAB_COLUMNS

Line 85: l_data_type dba_tab_columns.data_type%TYPE;

81: l_user_id ASG_USER.USER_ID%TYPE;
82: l_dodirty BOOLEAN;
83: l_title VARCHAR2(80);
84: l_schema_name FND_ORACLE_USERID.ORACLE_USERNAME%TYPE;
85: l_data_type dba_tab_columns.data_type%TYPE;
86: l_data_type_id NUMBER;
87: l_dsql VARCHAR2(4000);
88: l_cursorid NUMBER;
89: l_result NUMBER;

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