APPS.BEN_DM_GEN_MASTER dependencies on BEN_DM_TABLES

Line 26: l_generator_version ben_dm_tables.generator_version%type;

22: is
23:
24: -- used for indexing of pl/sql table.
25: l_count number;
26: l_generator_version ben_dm_tables.generator_version%type;
27:
28: l_phase_item_id ben_dm_phase_items.phase_item_id%type;
29: l_phase_id ben_dm_phases.phase_id%type;
30:

Line 47: from ben_dm_tables tbl,

43: ,tbl.table_name
44: ,tbl.table_alias
45: ,phs.phase_id
46: ,itm.phase_item_id
47: from ben_dm_tables tbl,
48: ben_dm_phase_items itm,
49: ben_dm_phases phs
50: where phs.migration_id = p_migration_id
51: and phs.phase_name = 'G'

Line 172: update ben_dm_tables

168: hr_dm_library.get_generator_version(l_generator_version);
169: --
170: -- update the last generated date for TUP/TDS for this table in hr_dm_tables
171: --
172: update ben_dm_tables
173: set last_generated_date = sysdate,
174: generator_version = l_generator_version
175: where table_id = l_csr_get_table_rec.table_id;
176:

Line 290: from ben_dm_tables tbl,

286: -- cursor to get table for which
287:
288: cursor csr_get_table is
289: select tbl.short_name
290: from ben_dm_tables tbl,
291: ben_dm_table_order dto
292: where tbl.table_id = dto.table_id
293: order by dto.table_order ;
294:

Line 330: l_short_name ben_dm_tables.short_name%type ;

326: l_last_migration_date date ;
327: l_fatal_error_message varchar2(200);
328: l_max_ext number := 32767;
329: l_pre_fix varchar2(10) ;
330: l_short_name ben_dm_tables.short_name%type ;
331: l_business_group_id number ;
332: l_phase_item_id number ;
333: l_phase_id number ;
334: l_current_phase_status varchar2(10) ;

Line 525: from ben_dm_tables tbl,

521: -- cursor to get table for which
522:
523: cursor csr_get_table is
524: select tbl.short_name
525: from ben_dm_tables tbl,
526: ben_dm_table_order dto
527: where tbl.table_id = dto.table_id
528: order by dto.table_order ;
529:

Line 562: l_short_name ben_dm_tables.short_name%type ;

558: l_phase_rec c_phase%rowtype;
559: l_last_migration_date date ;
560: l_fatal_error_message varchar2(200);
561: l_pre_fix varchar2(10) ;
562: l_short_name ben_dm_tables.short_name%type ;
563: l_business_group_id number ;
564: l_phase_item_id number ;
565: l_phase_id number ;
566: l_current_phase_status varchar2(10) ;