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
111: select vst1.*
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
186: select vst1.*