APPS.HR_DM_AOL_UP dependencies on HR_DM_MIGRATIONS

Line 87: FROM hr_dm_migrations dm,

83: AND pi.phase_item_id = lp.ua_phase_item_id;
84:
85: CURSOR csr_migration_info IS
86: SELECT sg.security_group_key
87: FROM hr_dm_migrations dm,
88: fnd_security_groups sg,
89: per_business_groups pbg
90: WHERE dm.migration_id = p_migration_id
91: AND dm.business_group_id = pbg.business_group_id

Line 268: FROM HR_DM_MIGRATIONS

264:
265: -- get the destination database name
266: SELECT DESTINATION_DATABASE_INSTANCE
267: INTO l_destination_database
268: FROM HR_DM_MIGRATIONS
269: WHERE migration_id = p_migration_id;
270:
271:
272: -- write data to UA file

Line 364: FROM hr_dm_migrations

360: ')', 10);
361:
362: SELECT business_group_id
363: INTO l_business_group_id
364: FROM hr_dm_migrations
365: WHERE migration_id = p_migration_id;
366:
367:
368: SELECT ORG_INFORMATION4,

Line 512: l_business_group_name hr_dm_migrations.business_group_name%type;

508: l_destination_db VARCHAR2(30);
509: l_migration_type VARCHAR2(30);
510: l_migration_type_meaning VARCHAR2(80);
511: l_business_group_id NUMBER;
512: l_business_group_name hr_dm_migrations.business_group_name%type;
513: l_selective_mc VARCHAR2(2000);
514:
515:
516: CURSOR csr_get_pi IS

Line 531: hr_dm_migrations mig

527: FROM hr_dm_groups grp,
528: hr_dm_application_groups apg,
529: hr_dm_table_groupings tbg,
530: hr_dm_tables tbl,
531: hr_dm_migrations mig
532: WHERE tbl.table_id = tbg.table_id
533: AND tbg.group_id = grp.group_id
534: AND grp.group_type = 'A'
535: AND grp.group_id = apg.group_id

Line 549: FROM hr_dm_migrations

545: migration_type),
546: business_group_id,
547: business_group_name,
548: selective_migration_criteria
549: FROM hr_dm_migrations
550: WHERE migration_id = p_migration_id;
551:
552:
553: --

Line 706: FROM HR_DM_MIGRATIONS

702:
703: -- get the destination database name
704: SELECT DESTINATION_DATABASE_INSTANCE
705: INTO l_destination_database
706: FROM HR_DM_MIGRATIONS
707: WHERE migration_id = p_migration_id;
708:
709:
710: utl_file.put_line(l_filehandle, '# Taskflow upload commands');