APPS.BEN_DM_GEN_UPLOAD dependencies on BEN_DM_TABLES

Line 257: l_locals := l_locals || ' from ben_dm_tables ' || indent ;

253: if p_table_info.table_name = 'BEN_LE_CLSN_N_RSTR' then
254:
255: l_locals := l_locals || 'Cursor c_pk_column (p_tbl_name varchar2) is ' || indent ;
256: l_locals := l_locals || 'select SURROGATE_PK_COLUMN_NAME ' || indent ;
257: l_locals := l_locals || ' from ben_dm_tables ' || indent ;
258: l_locals := l_locals || ' where table_name = p_tbl_name ' || indent ;
259: l_locals := l_locals || ' ; ' || indent ;
260: l_locals := l_locals || 'l_pk_column_name varchar2(80) ; ' || indent ;
261:

Line 319: from ben_dm_hierarchies bdm , ben_dm_tables bdt

315: ,bdm.column_name
316: ,bdm.parent_table_name
317: ,bdm.parent_column_name
318: ,bdm.parent_id_column_name
319: from ben_dm_hierarchies bdm , ben_dm_tables bdt
320: where bdm.table_id = c_tbl_id
321: and bdm.parent_table_name = bdt.table_name
322: ;
323:

Line 327: from ben_dm_hierarchies bdm , ben_dm_tables bdt

323:
324:
325: cursor c_H_hier (c_tbl_id number) is
326: select 'x'
327: from ben_dm_hierarchies bdm , ben_dm_tables bdt
328: where bdm.table_id = c_tbl_id
329: and bdm.parent_table_name = bdt.table_name
330: and bdm.hierarchy_type = 'H'
331: ;

Line 340: ben_dm_tables tab,

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
344: and col.column_name = map.column_name

Line 742: from ben_dm_tables

738: ,LAST_GENERATED_DATE
739: ,GENERATOR_VERSION
740: ,SEQUENCE_NAME
741: ,LAST_UPDATE_DATE
742: from ben_dm_tables
743: where table_alias = p_table_alias
744: ;
745: l_tbl_rec ben_dm_gen_download.t_ben_dm_table ;
746: