APPS.AHL_UMP_UTIL_PKG dependencies on AHL_VISIT_TASKS_B

Line 106: FROM ahl_visit_tasks_b tsk, (select vst1.*

102:
103: -- 11.5.10CU2: Ignore simulation visits.
104: CURSOR ahl_visit_csr(p_ue_id IN NUMBER) IS
105: SELECT vst.start_date_time, vst.visit_id
106: FROM ahl_visit_tasks_b tsk, (select vst1.*
107: from ahl_visits_b vst1, ahl_simulation_plans_b sim
108: where vst1.simulation_plan_id = sim.simulation_plan_id
109: and sim.primary_plan_flag = 'Y'
110: UNION ALL

Line 181: FROM ahl_visit_tasks_b tsk, (select vst1.*

177: -- 11.5.10CU2: Ignore simulation visits.
178: CURSOR ahl_visit_csr(p_ue_id IN NUMBER) IS
179:
180: SELECT decode(vst.status_code,'CLOSED', vst.status_code, tsk.status_code)
181: FROM ahl_visit_tasks_b tsk, (select vst1.*
182: from ahl_visits_b vst1, ahl_simulation_plans_b sim
183: where vst1.simulation_plan_id = sim.simulation_plan_id
184: and sim.primary_plan_flag = 'Y'
185: UNION ALL

Line 194: FROM ahl_visit_tasks_b tsk, ahl_visits_b vst

190: AND NVL(vst.status_code,'x') NOT IN ('DELETED','CANCELLED')
191: AND NVL(tsk.status_code,'x') NOT IN ('DELETED','CANCELLED')
192: AND tsk.unit_effectivity_id = p_ue_id;
193: /*
194: FROM ahl_visit_tasks_b tsk, ahl_visits_b vst
195: WHERE vst.visit_id = tsk.visit_id
196: AND NVL(vst.status_code,'x') NOT IN ('DELETED','CANCELLED')
197: AND NVL(tsk.status_code,'x') NOT IN ('DELETED','CANCELLED')
198: AND tsk.unit_effectivity_id = p_ue_id;