APPS.HR_DM_AOL_DOWN dependencies on HR_DM_PHASE_ITEMS

Line 82: hr_dm_phase_items pi

78: lpi.parameter_9, lpi.parameter_10,
79: lpi.application_id,
80: lpi.filename
81: FROM hr_dm_loader_phase_items lpi,
82: hr_dm_phase_items pi
83: WHERE (pi.phase_item_id = p_phase_item_id)
84: AND (lpi.da_phase_item_id = pi.phase_item_id);
85:
86: CURSOR csr_migration_info IS

Line 376: -- the hr_dm_phase_items table for the aol download phase and calls the

372: /*--------------------------- PUBLIC ROUTINES ---------------------------*/
373:
374: -- ------------------------- main ------------------------
375: -- Description: This is the aol download phase slave. It reads an item from
376: -- the hr_dm_phase_items table for the aol download phase and calls the
377: -- appropriate aol loader.
378: --
379: -- There are two paths through the code, dependent upon if the procedure is
380: -- called at the start of a phase item or after the slave has been awoken

Line 453: FROM hr_dm_phase_items pi,

449: l_business_group_id NUMBER;
450:
451: CURSOR csr_get_pi IS
452: SELECT pi.phase_item_id, pi.loader_name, pi.status
453: FROM hr_dm_phase_items pi,
454: hr_dm_tables tbl
455: WHERE (pi.status = 'NS')
456: AND (pi.phase_id = l_phase_id)
457: AND (pi.loader_name = tbl.loader_name)