APPS.HR_DM_RANGE dependencies on HR_DM_PHASE_ITEMS

Line 9: -- hr_dm_phase_items table for the range phase and calls the appropriate

5: /*---------------------------- PUBLIC ROUTINES ---------------------------*/
6:
7: -- ------------------------- main ------------------------
8: -- Description: This is the range phase slave. It reads an item from the
9: -- hr_dm_phase_items table for the range phase and calls the appropriate
10: -- TDS package to populate the table hr_dm_migration_ranges.
11: --
12: --
13: -- Input Parameters

Line 67: FROM hr_dm_phase_items pi,

63:
64:
65: CURSOR csr_get_pi IS
66: SELECT pi.phase_item_id, pi.table_name, pi.status, tbl.short_name
67: FROM hr_dm_phase_items pi,
68: hr_dm_tables tbl
69: WHERE pi.status = 'NS'
70: AND mod(pi.phase_item_id,l_no_of_threads) + 1 = p_process_number
71: AND pi.phase_id = l_phase_id