APPS.HR_DM_AOL_DOWN dependencies on HR_DM_TABLES

Line 454: hr_dm_tables tbl

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)
458: AND ((MOD(pi.phase_item_id, l_no_of_threads) + 1) = p_process_number);