APPS.CSM_LOBS_PKG dependencies on ALL_TAB_COLUMNS

Line 85: l_data_type all_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 all_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 146: select data_type from all_tab_columns

142: WHERE ORACLE_ID =883;
143:
144: CURSOR l_get_datatype (c_schema IN FND_ORACLE_USERID.ORACLE_USERNAME%TYPE)
145: IS
146: select data_type from all_tab_columns
147: where table_name = 'CSF_M_LOBS_INQ'
148: and column_name = 'FILE_DATA'
149: and OWNER = c_schema;
150: