APPS.BEN_DM_GEN_DOWNLOAD dependencies on BEN_DM_TABLES

Line 256: l_derive_sql ben_dm_tables.derive_sql%type;

252: p_table_info in t_ben_dm_table,
253: p_from_clause in out nocopy varchar2,
254: p_lpad_spaces in number default 2
255: ) is
256: l_derive_sql ben_dm_tables.derive_sql%type;
257: l_start_ptr number;
258: l_end_ptr number;
259: l_where_string varchar2(25) := 'where';
260: l_terminator varchar2(5) := ';';

Line 327: l_derive_sql ben_dm_tables.DERIVE_SQL%type ;

323: l_start_ptr number;
324: l_end_ptr number;
325: l_where_string varchar2(25) := 'where';
326: l_terminator varchar2(5) := ';';
327: l_derive_sql ben_dm_tables.DERIVE_SQL%type ;
328: l_proc varchar2(75);
329:
330:
331: begin

Line 513: from ben_dm_hierarchies bdm , ben_dm_tables bdt

509: ,bdm.column_name
510: ,bdm.parent_table_name
511: ,bdm.parent_column_name
512: ,bdm.parent_id_column_name
513: from ben_dm_hierarchies bdm , ben_dm_tables bdt
514: where bdm.HIERARCHY_TYPE = 'S'
515: and bdm.table_id = c_tbl_id
516: and bdm.parent_table_name = bdt.table_name
517: ;

Line 745: from ben_dm_tables

741: ,LAST_GENERATED_DATE
742: ,GENERATOR_VERSION
743: ,SEQUENCE_NAME
744: ,LAST_UPDATE_DATE
745: from ben_dm_tables
746: where table_alias = p_table_alias
747: ;
748: l_tbl_rec t_ben_dm_table ;
749: