APPS.BEN_DM_GEN_SELF_REF dependencies on BEN_DM_HIERARCHIES

Line 165: ben_dm_hierarchies bdh ,

161: cursor c_cols_map is
162: select bcm.column_name ,
163: bcm.entity_result_column_name
164: from ben_dm_column_mappings bcm ,
165: ben_dm_hierarchies bdh ,
166: ben_dm_Tables bdt
167: where bcm.table_id = bdh.table_id
168: and bdh.hierarchy_type = 'H'
169: and (bcm.column_name = bdh.column_name or bcm.column_name = bdt.surrogate_pk_column_name)

Line 289: from ben_dm_hierarchies bdh ,

285: bdh.parent_id_column_name,
286: bdh.column_name,
287: bdt.table_name,
288: bdt.surrogate_pk_column_name
289: from ben_dm_hierarchies bdh ,
290: ben_dm_Tables bdt
291: where bdh.hierarchy_type = 'H'
292: and bdh.table_id = bdt.table_id
293: order by bdh.table_id,bdh.column_name

Line 302: l_hierarchy_type ben_dm_hierarchies.hierarchy_type%type ;

298: l_indent number := 2;
299: l_proc_body_tbl t_varchar2_32k_tbl;
300: l_proc_index number := 1;
301: l_list_index number;
302: l_hierarchy_type ben_dm_hierarchies.hierarchy_type%type ;
303: l_parent_table_name ben_dm_hierarchies.parent_table_name%type ;
304: l_parent_id_column_name ben_dm_hierarchies.parent_id_column_name%type ;
305: l_proc varchar2(75) ;
306:

Line 303: l_parent_table_name ben_dm_hierarchies.parent_table_name%type ;

299: l_proc_body_tbl t_varchar2_32k_tbl;
300: l_proc_index number := 1;
301: l_list_index number;
302: l_hierarchy_type ben_dm_hierarchies.hierarchy_type%type ;
303: l_parent_table_name ben_dm_hierarchies.parent_table_name%type ;
304: l_parent_id_column_name ben_dm_hierarchies.parent_id_column_name%type ;
305: l_proc varchar2(75) ;
306:
307: begin

Line 304: l_parent_id_column_name ben_dm_hierarchies.parent_id_column_name%type ;

300: l_proc_index number := 1;
301: l_list_index number;
302: l_hierarchy_type ben_dm_hierarchies.hierarchy_type%type ;
303: l_parent_table_name ben_dm_hierarchies.parent_table_name%type ;
304: l_parent_id_column_name ben_dm_hierarchies.parent_id_column_name%type ;
305: l_proc varchar2(75) ;
306:
307: begin
308: l_proc := g_package || 'generate_update_dml' ;