APPS.BEN_DM_GEN_UPLOAD dependencies on BEN_DM_COLUMN_MAPPINGS

Line 164: from ben_dm_column_mappings a ,

160:
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

Line 339: from ben_dm_column_mappings map,

335: cursor c_cols_map (c_tbl_id number) is
336: select decode(col.data_type,'DATE','to_char(l_rslt.'||map.column_name||','||''''||'dd-mon-rrrr'||''''||')','l_rslt.'
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