APPS.HR_DM_GEN_MAIN dependencies on HR_DM_PHASES

Line 266: hr_dm_phases phs

262: ,itm.phase_item_id
263: ,phs.phase_id
264: from hr_dm_tables tbl,
265: hr_dm_phase_items itm,
266: hr_dm_phases phs
267: where phs.migration_id = p_migration_id
268: and phs.phase_name = 'R'
269: and phs.phase_id = itm.phase_id
270: and itm.table_name = tbl.table_name;

Line 277: hr_dm_phases phs

273: -- than 'Complete'. If yes then it needs re-generating.
274: cursor csr_chk_generate_status (p_table_name varchar2)is
275: select '1'
276: from hr_dm_phase_items itm,
277: hr_dm_phases phs
278: where phs.migration_id = p_migration_id
279: and phs.phase_name = 'G'
280: and phs.phase_id = itm.phase_id
281: and itm.table_name = p_table_name

Line 307: hr_dm_phases phs

303: av.text,
304: itm.phase_item_id
305: from all_views av,
306: hr_dm_phase_items itm,
307: hr_dm_phases phs
308: where phs.migration_id = p_migration_id
309: and phs.phase_name = 'G'
310: and phs.phase_id = itm.phase_id
311: and itm.table_name = av.view_name

Line 454: l_phase_id hr_dm_phases.phase_id%type;

450: l_aol_parameters_tbl hr_dm_library.t_varchar2_tbl;
451:
452: l_fk_to_aol_columns_tbl t_fk_to_aol_columns_tbl;
453: l_phase_item_id hr_dm_phase_items.phase_item_id%type;
454: l_phase_id hr_dm_phases.phase_id%type;
455:
456: l_generator_version hr_dm_tables.generator_version%type;
457:
458: l_current_phase_status varchar2(30);

Line 489: hr_dm_phases phs,

485: ,phs.migration_id
486: ,lower(nvl(tbl.upload_table_name, tbl.table_name)) upload_table_name
487: ,sequence_name
488: from hr_dm_tables tbl,
489: hr_dm_phases phs,
490: hr_dm_phase_items itm
491: where itm.phase_item_id = p_phase_item_id
492: and itm.phase_id = phs.phase_id
493: and itm.table_name = tbl.table_name;

Line 908: l_phase_id hr_dm_phases.phase_id%type;

904: l_aol_parameters_tbl hr_dm_library.t_varchar2_tbl;
905:
906: l_fk_to_aol_columns_tbl t_fk_to_aol_columns_tbl;
907: l_phase_item_id hr_dm_phase_items.phase_item_id%type;
908: l_phase_id hr_dm_phases.phase_id%type;
909:
910: l_current_phase_status varchar2(30);
911: e_fatal_error exception;
912: e_fatal_error2 exception;

Line 953: hr_dm_phases phs

949: ,lower(nvl(tbl.upload_table_name, tbl.table_name)) upload_table_name
950: ,sequence_name
951: from hr_dm_tables tbl,
952: hr_dm_phase_items itm,
953: hr_dm_phases phs
954: where phs.migration_id = p_migration_id
955: and phs.phase_name = 'G'
956: and phs.phase_id = itm.phase_id
957: and mod(itm.phase_item_id,l_no_of_threads) + 1 = p_process_number