APPS.HR_DM_DELETE dependencies on HR_DM_APPLICATION_GROUPS

Line 37: FROM hr_dm_application_groups

33:
34:
35: CURSOR csr_get_active IS
36: SELECT group_id
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,

Line 46: hr_dm_application_groups apg

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
49: AND pi_rg.table_name = tbl.table_name
50: AND pi_dn.phase_id = l_delete_phase_id

Line 355: FROM hr_dm_application_groups

351: WHERE migration_id = p_migration_id;
352:
353: CURSOR csr_group_work IS
354: SELECT group_id
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,

Line 364: hr_dm_application_groups apg

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
367: AND pi_rg.table_name = tbl.table_name
368: AND pi_dn.phase_id = l_delete_phase_id