DBA Data[Home] [Help]

APPS.HR_DM_INIT dependencies on HR_DM_TABLE_GROUPINGS

Line 178: FROM hr_dm_tables tbl, hr_dm_table_groupings tbg,

174: -- (last_update_date > last_generated_date)
175:
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)

Line 204: FROM hr_dm_tables tbl, hr_dm_table_groupings tbg,

200: tbl.last_update_date))
201: )
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)

Line 230: FROM hr_dm_tables tbl, hr_dm_table_groupings tbg,

226: tbl.last_update_date))
227: )
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)

Line 356: FROM hr_dm_tables tbl, hr_dm_table_groupings tbg,

352: l_table_name VARCHAR2(30);
353:
354: CURSOR csr_select_pi IS
355: SELECT tbg.group_id, tbl.table_name
356: FROM hr_dm_tables tbl, hr_dm_table_groupings tbg,
357: hr_dm_groups grp, hr_dm_application_groups apg
358: WHERE ( (tbl.table_id = tbg.table_id)
359: AND (tbg.group_id = grp.group_id)
360: AND (grp.group_type = 'D')

Line 778: hr_dm_table_groupings tbg,

774: tbl.loader_application,
775: grp.group_id
776: FROM hr_dm_groups grp,
777: hr_dm_application_groups apg,
778: hr_dm_table_groupings tbg,
779: hr_dm_tables tbl
780: WHERE tbl.table_id = tbg.table_id
781: AND tbg.group_id = grp.group_id
782: AND grp.group_type = 'A'

Line 952: hr_dm_table_groupings tbg,

948: lp.parameter10,
949: grp.group_id
950: FROM hr_dm_groups grp,
951: hr_dm_application_groups apg,
952: hr_dm_table_groupings tbg,
953: hr_dm_tables tbl,
954: hr_dm_loader_params lp
955: WHERE (lp.table_id = tbl.table_id)
956: AND (lp.application_id = r_migration_data.application_id)

Line 1585: hr_dm_table_groupings tbg,

1581: lp.loader_params_id,
1582: grp.group_id
1583: FROM hr_dm_groups grp,
1584: hr_dm_application_groups apg,
1585: hr_dm_table_groupings tbg,
1586: hr_dm_tables tbl,
1587: hr_dm_loader_params lp
1588: WHERE (lp.table_id = tbl.table_id)
1589: AND (lp.application_id = r_migration_data.application_id)

Line 1774: hr_dm_table_groupings tbg,

1770: lp.loader_params_id,
1771: grp.group_id
1772: FROM hr_dm_groups grp,
1773: hr_dm_application_groups apg,
1774: hr_dm_table_groupings tbg,
1775: hr_dm_tables tbl,
1776: hr_dm_loader_params lp
1777: WHERE (lp.table_id = tbl.table_id)
1778: AND (lp.application_id = r_migration_data.application_id)