DBA Data[Home] [Help]

APPS.HR_DM_UTILITY dependencies on HR_DM_TABLES

Line 993: hr_dm_tables tbl,

989: mr.starting_process_sequence,
990: mr.ending_process_sequence,
991: mr.range_id
992: FROM hr_dm_migration_ranges mr,
993: hr_dm_tables tbl,
994: hr_dm_phase_items pi
995: WHERE (pi.phase_id = l_range_phase_id)
996: AND (pi.phase_item_id = mr.phase_item_id)
997: AND (pi.table_name = tbl.table_name)

Line 1003: hr_dm_tables tbl,

999:
1000: CURSOR csr_c3 IS
1001: SELECT pi.batch_id
1002: FROM hr_dm_migration_ranges mr,
1003: hr_dm_tables tbl,
1004: hr_dm_phase_items pi,
1005: hr_dm_table_groupings tgp
1006: WHERE (pi.phase_id = l_phase_id)
1007: AND (pi.group_id = tgp.group_id)

Line 1576: hr_dm_tables tbl,

1572: -- find parent phase item id
1573: CURSOR csr_par_pi_id IS
1574: SELECT pi_par.phase_item_id
1575: FROM hr_dm_phase_items pi_par,
1576: hr_dm_tables tbl,
1577: hr_dm_migration_ranges mr,
1578: hr_dm_phase_items pi_rg,
1579: hr_dm_table_groupings tgp
1580: WHERE p_id = mr.range_id