APPS.HR_DM_AOL_UP dependencies on HR_DM_PHASE_ITEMS

Line 81: hr_dm_phase_items pi

77: lp.parameter_9, lp.parameter_10,
78: lp.application_id,
79: lp.filename
80: FROM hr_dm_loader_phase_items lp,
81: hr_dm_phase_items pi
82: WHERE pi.phase_item_id = p_phase_item_id
83: AND pi.phase_item_id = lp.ua_phase_item_id;
84:
85: CURSOR csr_migration_info IS

Line 443: -- the hr_dm_phase_items table for the aol upload phase and calls the

439:
440:
441: -- ------------------------- main ------------------------
442: -- Description: This is the aol upload phase slave. It reads an item from
443: -- the hr_dm_phase_items table for the aol upload phase and calls the
444: -- appropriate aol loader.
445: --
446: --
447: -- On a non-first run (l_request_data <> null), the status of the slave

Line 519: FROM hr_dm_phase_items pi

515:
516: CURSOR csr_get_pi IS
517: SELECT pi.phase_item_id,
518: pi.status
519: FROM hr_dm_phase_items pi
520: WHERE (pi.status = 'NS')
521: AND (pi.phase_id = l_phase_id)
522: AND (pi.loader_name = l_loader_group)
523: ORDER BY pi.phase_item_id;