APPS.HR_DM_DELETE dependencies on HR_DM_PHASE_ITEMS

Line 41: FROM hr_dm_phase_items pi_dn,

37: FROM hr_dm_application_groups
38: WHERE (migration_type = 'D')
39: AND (group_order IN (
40: SELECT MAX(apg.group_order)
41: FROM hr_dm_phase_items pi_dn,
42: hr_dm_tables tbl,
43: hr_dm_migration_ranges mr,
44: hr_dm_phase_items pi_rg,
45: hr_dm_table_groupings tgp,

Line 44: hr_dm_phase_items pi_rg,

40: SELECT MAX(apg.group_order)
41: FROM hr_dm_phase_items pi_dn,
42: hr_dm_tables tbl,
43: hr_dm_migration_ranges mr,
44: hr_dm_phase_items pi_rg,
45: hr_dm_table_groupings tgp,
46: hr_dm_application_groups apg
47: WHERE pi_rg.phase_id = l_range_phase_id
48: AND pi_rg.phase_item_id = mr.phase_item_id

Line 359: FROM hr_dm_phase_items pi_dn,

355: FROM hr_dm_application_groups
356: WHERE (migration_type = 'D')
357: AND (group_order IN (
358: SELECT MAX(apg.group_order)
359: FROM hr_dm_phase_items pi_dn,
360: hr_dm_tables tbl,
361: hr_dm_migration_ranges mr,
362: hr_dm_phase_items pi_rg,
363: hr_dm_table_groupings tgp,

Line 362: hr_dm_phase_items pi_rg,

358: SELECT MAX(apg.group_order)
359: FROM hr_dm_phase_items pi_dn,
360: hr_dm_tables tbl,
361: hr_dm_migration_ranges mr,
362: hr_dm_phase_items pi_rg,
363: hr_dm_table_groupings tgp,
364: hr_dm_application_groups apg
365: WHERE pi_rg.phase_id = l_range_phase_id
366: AND pi_rg.phase_item_id = mr.phase_item_id

Line 383: FROM hr_dm_phase_items pi_del,

379: tbl.short_name,
380: mr.starting_process_sequence,
381: mr.ending_process_sequence,
382: pi_del.phase_item_id
383: FROM hr_dm_phase_items pi_del,
384: hr_dm_tables tbl,
385: hr_dm_migration_ranges mr,
386: hr_dm_phase_items pi_rg,
387: hr_dm_table_groupings tgp

Line 386: hr_dm_phase_items pi_rg,

382: pi_del.phase_item_id
383: FROM hr_dm_phase_items pi_del,
384: hr_dm_tables tbl,
385: hr_dm_migration_ranges mr,
386: hr_dm_phase_items pi_rg,
387: hr_dm_table_groupings tgp
388: WHERE pi_rg.phase_id = l_range_phase_id
389: AND pi_rg.phase_item_id = mr.phase_item_id
390: AND mr.status = 'NS'

Line 718: utl_file.put_line(l_filehandle, ' from hr_dm_phase_items');

714:
715: utl_file.put_line(l_filehandle, 'delete from hr_dm_migration_ranges');
716: utl_file.put_line(l_filehandle, 'where phase_item_id in');
717: utl_file.put_line(l_filehandle, ' (select phase_item_id');
718: utl_file.put_line(l_filehandle, ' from hr_dm_phase_items');
719: utl_file.put_line(l_filehandle, ' where phase_id in');
720: utl_file.put_line(l_filehandle, ' (select phase_id');
721: utl_file.put_line(l_filehandle, ' from hr_dm_phases');
722: utl_file.put_line(l_filehandle, ' where migration_id in');

Line 729: utl_file.put_line(l_filehandle, 'delete from hr_dm_phase_items');

725: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||
726: r_migration_data.business_group_id || ')));');
727: utl_file.put_line(l_filehandle, '');
728:
729: utl_file.put_line(l_filehandle, 'delete from hr_dm_phase_items');
730: utl_file.put_line(l_filehandle, 'where phase_item_id in');
731: utl_file.put_line(l_filehandle, ' (select phase_item_id');
732: utl_file.put_line(l_filehandle, ' from hr_dm_phase_items');
733: utl_file.put_line(l_filehandle, ' where phase_id in');

Line 732: utl_file.put_line(l_filehandle, ' from hr_dm_phase_items');

728:
729: utl_file.put_line(l_filehandle, 'delete from hr_dm_phase_items');
730: utl_file.put_line(l_filehandle, 'where phase_item_id in');
731: utl_file.put_line(l_filehandle, ' (select phase_item_id');
732: utl_file.put_line(l_filehandle, ' from hr_dm_phase_items');
733: utl_file.put_line(l_filehandle, ' where phase_id in');
734: utl_file.put_line(l_filehandle, ' (select phase_id');
735: utl_file.put_line(l_filehandle, ' from hr_dm_phases');
736: utl_file.put_line(l_filehandle, ' where migration_id in');