APPS.HR_DM_INIT dependencies on HR_DM_MIGRATIONS

Line 180: hr_dm_migrations mig

176: CURSOR csr_select_pi IS
177: SELECT DISTINCT tbl.loader_name, tbg.group_id, tbl.table_name
178: FROM hr_dm_tables tbl, hr_dm_table_groupings tbg,
179: all_objects obj, hr_dm_application_groups app,
180: hr_dm_migrations mig
181: WHERE (tbl.table_id = tbg.table_id)
182: AND (app.group_id = tbg.group_id)
183: AND (mig.application_id = app.application_id)
184: AND (mig.migration_id = r_migration_data.migration_id)

Line 206: hr_dm_migrations mig

202: UNION
203: SELECT DISTINCT tbl.loader_name, tbg.group_id, tbl.table_name
204: FROM hr_dm_tables tbl, hr_dm_table_groupings tbg,
205: all_objects obj, hr_dm_application_groups app,
206: hr_dm_migrations mig
207: WHERE (tbl.table_id = tbg.table_id)
208: AND (app.group_id = tbg.group_id)
209: AND (mig.application_id = app.application_id)
210: AND (mig.migration_id = r_migration_data.migration_id)

Line 232: hr_dm_migrations mig

228: UNION
229: SELECT DISTINCT tbl.loader_name, tbg.group_id, tbl.table_name
230: FROM hr_dm_tables tbl, hr_dm_table_groupings tbg,
231: hr_dm_application_groups app,
232: hr_dm_migrations mig
233: WHERE (tbl.table_id = tbg.table_id)
234: AND (app.group_id = tbg.group_id)
235: AND (mig.application_id = app.application_id)
236: AND (mig.migration_id = r_migration_data.migration_id)

Line 990: hr_dm_migrations mig

986: fc.descriptive_flex_context_code
987: FROM fnd_descr_flex_contexts_vl fc,
988: fnd_descriptive_flexs_vl f,
989: fnd_application a,
990: hr_dm_migrations mig
991: WHERE fc.descriptive_flexfield_name =
992: f.descriptive_flexfield_name
993: AND f.application_id = a.application_id
994: AND a.application_short_name IN ('PER','PAY','BEN','FND')

Line 1203: l_business_group_name hr_dm_migrations.business_group_name%type;

1199:
1200: l_phase_id NUMBER;
1201: l_group_id NUMBER;
1202: l_batch_id NUMBER;
1203: l_business_group_name hr_dm_migrations.business_group_name%type;
1204: l_batch_name VARCHAR2(80);
1205: l_group_text VARCHAR2(240);
1206:
1207: CURSOR csr_select_pi IS

Line 1218: FROM per_business_groups pbg, hr_dm_migrations mig

1214: ORDER BY apg.group_order;
1215:
1216: CURSOR csr_select_bg_name IS
1217: SELECT pbg.name
1218: FROM per_business_groups pbg, hr_dm_migrations mig
1219: WHERE ((mig.migration_id = r_migration_data.migration_id)
1220: AND (mig.business_group_id = pbg.business_group_id));
1221:
1222:

Line 1403: l_business_group_name hr_dm_migrations.business_group_name%type;

1399:
1400: l_phase_id NUMBER;
1401: l_group_id NUMBER;
1402: l_batch_id NUMBER;
1403: l_business_group_name hr_dm_migrations.business_group_name%type;
1404: l_batch_name VARCHAR2(80);
1405: l_group_text VARCHAR2(240);
1406: l_batch_start NUMBER;
1407: l_batch_end NUMBER;