DBA Data[Home] [Help]

APPS.BEN_DM_GEN_UPLOAD dependencies on ALL_TAB_COLUMNS

Line 165: sys.all_tab_columns b

161: cursor c_cols_map (c_tbl_id number , c_table_name varchar2) is
162: select a.column_name ,
163: a.entity_result_column_name
164: from ben_dm_column_mappings a ,
165: sys.all_tab_columns b
166: where a.table_id = c_tbl_id
167: and a.column_name = b.column_name
168: and b.table_name = c_table_name
169: order by b.column_id

Line 341: sys.all_tab_columns col

337: ||map.column_name) column_name ,
338: map.entity_result_column_name
339: from ben_dm_column_mappings map,
340: ben_dm_tables tab,
341: sys.all_tab_columns col
342: where tab.table_id = c_tbl_id
343: and map.table_id = tab.table_id
344: and col.column_name = map.column_name
345: and col.table_name = tab.table_name