DBA Data[Home] [Help]

APPS.HR_DM_INIT dependencies on ALL_OBJECTS

Line 179: all_objects obj, hr_dm_application_groups app,

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)
183: AND (mig.application_id = app.application_id)

Line 205: all_objects obj, hr_dm_application_groups app,

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)
209: AND (mig.application_id = app.application_id)