APPS.BEN_DM_GEN_UPLOAD dependencies on BEN_DM_HIERARCHIES

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 353: from ben_dm_hierarchies bdh

349: cursor hier_type (p_col_name varchar2) is
350: select bdh.hierarchy_type ,
351: bdh.parent_table_name,
352: bdh.parent_id_column_name
353: from ben_dm_hierarchies bdh
354: where bdh.table_id = p_table_info.table_id
355: and bdh.column_name= p_col_name
356: ;
357:

Line 363: l_hierarchy_type ben_dm_hierarchies.hierarchy_type%type ;

359: l_indent number := 2;
360: l_proc_body_tbl t_varchar2_32k_tbl;
361: l_proc_index number := 1;
362: l_list_index number;
363: l_hierarchy_type ben_dm_hierarchies.hierarchy_type%type ;
364: l_parent_table_name ben_dm_hierarchies.parent_table_name%type ;
365: l_parent_id_column_name ben_dm_hierarchies.parent_id_column_name%type ;
366: l_proc varchar2(75) ;
367: l_h_hierarcy varchar2(1) ;

Line 364: l_parent_table_name ben_dm_hierarchies.parent_table_name%type ;

360: l_proc_body_tbl t_varchar2_32k_tbl;
361: l_proc_index number := 1;
362: l_list_index number;
363: l_hierarchy_type ben_dm_hierarchies.hierarchy_type%type ;
364: l_parent_table_name ben_dm_hierarchies.parent_table_name%type ;
365: l_parent_id_column_name ben_dm_hierarchies.parent_id_column_name%type ;
366: l_proc varchar2(75) ;
367: l_h_hierarcy varchar2(1) ;
368: l_dummy varchar2(1) ;

Line 365: l_parent_id_column_name ben_dm_hierarchies.parent_id_column_name%type ;

361: l_proc_index number := 1;
362: l_list_index number;
363: l_hierarchy_type ben_dm_hierarchies.hierarchy_type%type ;
364: l_parent_table_name ben_dm_hierarchies.parent_table_name%type ;
365: l_parent_id_column_name ben_dm_hierarchies.parent_id_column_name%type ;
366: l_proc varchar2(75) ;
367: l_h_hierarcy varchar2(1) ;
368: l_dummy varchar2(1) ;
369: