APPS.BEN_DM_GEN_MASTER dependencies on BEN_DM_PHASES

Line 29: l_phase_id ben_dm_phases.phase_id%type;

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;
33: e_fatal_error2 exception;

Line 49: ben_dm_phases phs

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
53: and mod(itm.phase_item_id,l_no_of_threads) + 1 = p_process_number

Line 310: ben_dm_phases phs

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
314: and mod(itm.phase_item_id,l_no_of_threads) + 1 = p_process_number

Line 535: ben_dm_phases phs

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'
539: and mod(itm.phase_item_id,l_no_of_threads) + 1 = p_process_number