APPS.AHL_UMP_SMRINSTANCE_PVT dependencies on BOM_DEPARTMENTS
Line 222: bom_departments bdpt
218: select vst1.* from
219: ahl_visits_b vst1
220: where simulation_plan_id IS NULL)vst,
221: hr_all_organization_units hrou, 222: bom_departments bdpt 223: WHERE vst.visit_id = tsk.visit_id
224: AND NVL(vst.status_code,'x') NOT IN ('DELETED','CANCELLED')
225: AND NVL(tsk.status_code,'x') NOT IN ('DELETED','CANCELLED')
226: AND tsk.unit_effectivity_id = p_ue_id