APPS.BEN_DM_GEN_MASTER dependencies on BEN_DM_PHASE_ITEMS

Line 28: l_phase_item_id ben_dm_phase_items.phase_item_id%type;

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:
31: l_current_phase_status varchar2(30);
32: e_fatal_error exception;

Line 48: ben_dm_phase_items itm,

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'
52: and phs.phase_id = itm.phase_id

Line 309: from ben_dm_phase_items itm,

305:
306: cursor c_input_file2 is
307: select itm.phase_item_id
308: ,itm.input_file_id
309: from ben_dm_phase_items itm,
310: ben_dm_phases phs
311: where phs.migration_id = p_migration_id
312: and phs.phase_name = 'DP'
313: and phs.phase_id = itm.phase_id

Line 534: from ben_dm_phase_items itm,

530: cursor c_phase is
531: select itm.phase_item_id
532: ,itm.phase_id
533: ,itm.group_order
534: from ben_dm_phase_items itm,
535: ben_dm_phases phs
536: where phs.migration_id = p_migration_id
537: and phs.phase_id = itm.phase_id
538: and phs.phase_name = 'UP'