APPS.HR_DM_CLEANUP dependencies on HR_DM_PHASE_ITEMS

Line 70: hr_dm_phase_items pi

66: lp.parameter7, lp.parameter10,
67: lp.application_id
68: FROM hr_dm_tables tbl,
69: hr_dm_loader_params lp,
70: hr_dm_phase_items pi
71: WHERE (pi.phase_item_id = p_phase_item_id)
72: AND (pi.loader_params_id = lp.loader_params_id)
73: AND (lp.table_id = tbl.table_id);
74:

Line 196: -- hr_dm_phase_items table for the cleanup phase and calls the appropriate

192: /*--------------------------- PUBLIC ROUTINES ----------------------------*/
193:
194: -- ------------------------- main ------------------------
195: -- Description: This is the cleanup phase slave. It reads an item from the
196: -- hr_dm_phase_items table for the cleanup phase and calls the appropriate
197: -- code (spawn_cleanup) to spawn slaves to process each phase item.
198: --
199: --
200: -- Input Parameters

Line 251: FROM hr_dm_phase_items pi,

247:
248:
249: CURSOR csr_get_pi IS
250: SELECT pi.phase_item_id, pi.loader_name, pi.status
251: FROM hr_dm_phase_items pi,
252: hr_dm_tables tbl
253: WHERE (pi.status = 'NS')
254: AND (pi.phase_id = l_phase_id)
255: AND (pi.loader_name = tbl.loader_name);