APPS.HR_DM_UPLOAD dependencies on HR_DM_APPLICATION_GROUPS

Line 151: hr_dm_application_groups apg

147: SELECT pi.phase_item_id,
148: pi.status,
149: pi.batch_id
150: FROM hr_dm_phase_items pi,
151: hr_dm_application_groups apg
152: WHERE pi.status = 'NS'
153: AND pi.phase_id = l_phase_id
154: AND pi.group_id = apg.group_id
155: ORDER BY apg.group_order;