APPS.HRI_UTL_STAGE_TABLE dependencies on ALL_TAB_COLS

Line 158: FROM all_tab_cols a

154: column_name
155: ,DECODE(data_type,
156: 'VARCHAR2', data_type || '(' || data_length || ')',
157: data_type) data_type
158: FROM all_tab_cols a
159: WHERE table_name = p_master_table_name
160: AND owner = p_owner
161: AND NOT EXISTS
162: (SELECT

Line 164: FROM all_tab_cols b

160: AND owner = p_owner
161: AND NOT EXISTS
162: (SELECT
163: null
164: FROM all_tab_cols b
165: WHERE b.table_name = v_table_name
166: AND b.owner = p_owner
167: AND b.column_name = a.column_name);
168:

Line 175: FROM all_tab_cols a

171: column_name
172: ,DECODE(data_type,
173: 'VARCHAR2', data_type || '(' || data_length || ')',
174: data_type) data_type
175: FROM all_tab_cols a
176: WHERE table_name = p_master_table_name
177: AND owner = p_owner
178: AND data_type = 'VARCHAR2'
179: AND EXISTS

Line 182: FROM all_tab_cols b

178: AND data_type = 'VARCHAR2'
179: AND EXISTS
180: (SELECT
181: null
182: FROM all_tab_cols b
183: WHERE b.table_name = v_table_name
184: AND b.owner = p_owner
185: AND b.column_name = a.column_name
186: AND b.data_length < a.data_length);

Line 312: FROM all_tab_cols

308: l_col_list VARCHAR2(32000);
309:
310: CURSOR column_csr IS
311: SELECT column_name
312: FROM all_tab_cols
313: WHERE table_name = p_master_table_name
314: AND owner = p_owner;
315:
316: BEGIN