DBA Data[Home] [Help]

APPS.HR_DM_RANGE dependencies on HR_DM_TABLES

Line 68: hr_dm_tables tbl

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
72: AND pi.table_name = tbl.table_name;