APPS.AHL_UMP_UTIL_PKG dependencies on AHL_WORKORDERS

Line 134: from ahl_workorders awo, ahl_visit_tasks_b tsk

130: CURSOR get_wo_dt (p_unit_effectivity_id IN NUMBER) IS
131: SELECT max(scheduled_completion_date)
132: FROM wip_discrete_jobs
133: WHERE wip_entity_id IN (select wip_entity_id
134: from ahl_workorders awo, ahl_visit_tasks_b tsk
135: where awo.visit_task_id = tsk.visit_task_id
136: and tsk.task_type_code <> 'SUMMARY'
137: and awo.status_code NOT IN ('17','22','7')
138: and tsk.unit_effectivity_id = p_unit_effectivity_id);