APPS.AHL_UMP_SMRINSTANCE_PVT dependencies on BOM_DEPARTMENTS

Line 211: bom_departments bdpt

207: select vst1.* from
208: ahl_visits_b vst1
209: where simulation_plan_id IS NULL)vst,
210: hr_all_organization_units hrou,
211: bom_departments bdpt
212: WHERE vst.visit_id = tsk.visit_id
213: AND NVL(vst.status_code,'x') NOT IN ('DELETED','CANCELLED')
214: AND NVL(tsk.status_code,'x') NOT IN ('DELETED','CANCELLED')
215: AND tsk.unit_effectivity_id = p_ue_id