DBA Data[Home] [Help]

APPS.AHL_UMP_SMRINSTANCE_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 210: hr_all_organization_units hrou,

206: UNION ALL
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')